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. A macro is an action or ...

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

So, in this case, it will delete row 4, then rows 12 to 14, then row 16, and so on. In total, there are 11,873 areas in this data, so Excel has to perform the delete operation 11,873 times!