Delete rows

How to delete rows in Microsoft Excel?


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

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

• Select the entire row
• RIGHT CLICK ->DELETE

If you want to delete more than one row 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 rows by pressing CTRL+Y. But to use this option you must have deleted the column from the EDIT menu.

Also see,
Delete columns
Insert columns
Insert rows