Thursday, February 15, 2007

Delete columns

How to delete columns in Microsoft Excel?


To delete rows RIGHT CLICK->DELETE->ENTIRE COLUMN
Alternatively, you may select the column you want to delete and EDIT-> DELETE->ENTIRE COLUMN. (This is not at all a shortcut)

If you want to delete column in a single click, you should

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

You can also repeat deleting columns by pressing CTRL+Y. But to use this option you must have deleted the column from the EDIT menu.

Also see,
Delete rows
Insert columns
Insert rows

No comments: