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 ...

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 ...

As a result, when Excel goes to delete the rows on show, it has to run through each group of contiguous cells (also known as an area) one by one. So, in this case, it will delete row 4, then rows ...