Friday, 10 May 2013

How to Delete Rows, Column and Work Sheet in Microsoft Excel:

How to Delete Rows, Column and Work Sheet:

If we want to delete some rows, columns from worksheet/database, we can use Delete Option from Cell group of Home Tab. It will delete current row or column where Mouse Handle is positioned.
Same option can be used to delete the entire work sheet. After clicking delete sheet option, excel displays a warning that whole data is going to be delete.  More importantly delete sheet action cannot be undo, so confirm it before clicking delete sheet. Undo can be used after deleting rows and column.

Delete sheet option can be used from right click on work sheet tab. Remember that undo can not be used after deleting sheet.

No comments:

Post a comment