Thursday, 9 May 2013

How to Insert Rows, Column and new work sheet in Microsoft Excel


How to Insert Rows, Column and new work sheet in Microsoft Excel:

As we know there are 16384 columns and 1048576 rows available in MS excel 2007/2010. But if we have prepared a list or database and after that we need row/column in between then there are options to insert rows and columns also.

Therefor we have to use Insert Option in Home Tab (Cells Group), don’t confuse with Insert Tab. Its Insert option in Home Tab. Using this option we can insert row, column, cells and even new worksheets also.

By default there are three sheets in workbook. (That default value can be changed from Excel Options)

Insert Row option provides an additional row above the mouse handle position. It does not ask for row above or below (like MS word table menus). Therefore Mouse handle position is important for this option.

Same case with Insert Column option, Excel provide additional column towards left side to Mouse handle.

Note:

1.       Adding new column is just adjustment into total available column (16384 columns). If all the 16384 columns are already filled, then excel will not insert new column. More importantly if anything entered in last column (XFD) then also excel does not insert new column.

2.       Adding new Row is just adjustment into total available row (1048576 rows). If all the 1048576 rows are already filled, then excel will not insert new row. More importantly if anything entered in last row (1048576) then also excel does not insert new row.

3.       There is no particular limit of maximum number of work sheet, it depends on memory of computer.

 


 

 

No comments:

Post a comment