Deleting rows from a large filtered range in Microsoft Excel can take a long time, temporarily place the program into a "not responding" state, or—in a worst-case scenario—cause Excel to crash ...

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

To delete a cell, put your cursor in the cell and press Ctrl+– (that’s Control and the minus key in the numeric keypad). It’ll instantly bring up the delete cell menu. To highlight a column without ...