Now from the drop-down menu select ‘Delete Sheet Rows’ to remove the unwanted rows. 2] Delete multiple rows in Excel using Shortcut Here we will use one of the most used shortcut keys i.e ...

In most spreadsheets, blank rows are undesirable. Microsoft Excel uses blanks to determine data ranges, and a blank row in the wrong place will inhibit many built-in features.

Let’s use it to delete all of the beverage records (column E) in the simple data set shown in Figure A. First, select the data range that you’re deleting rows from; in our case that’s E3:E47 ...