Thursday, February 15, 2007

Insert Columns

How to insert columns in Microsoft Excel?
How to insert more than one column at a time?

To insert rows, select the cells above which you want to insert rows. Go to the INSERT menu and select COLUMNS. Alternatively, you can RIGHT CLICK->INSERT->ENTIRE COLUMN to insert a column.
If you want to insert column in a single click, you should

  • Select the entire column
  • RIGHT CLICK ->INSERT
If you want to insert more than one column in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

If you insert a column it is normally inserted to the left of the cell. So if you insert a column from B2 it would be inserted to the left of B2

You can also repeat inserting columns by pressing CTRL+Y. But to use this option you must have insert column from the Insert menu.

Also see,
Insert rows
Delete rows
Delete columns

No comments: