4] Delete multiple Rows by running a Macro. For those who have tasks in Microsoft Excel that they need to do repeatedly, it can be easily be automated by recording a macro.

If you’ve selected a block of contiguous rows, Excel will delete them all. A keyboard shortcut is also available: Ctrl + -. This shortcut works with multiple rows and even non-contiguous selections.