MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to delete multiple rows?

Posted by Aaron on January 26, 2002 9:19 PM

I have a data spread sheet I would like to delete all rows which contains an empty cell (no data in them, they are on different rows and all over the spreadsheet)without going through manually clicking one by one (I have been using control/click) and deleting the rows, does anyone know how do I get it done in a simpler way? Thanks.

Posted by Puck on January 26, 2002 9:47 PM

Try using Edit>GoTo>Special>Blanks

Posted by Bariloche on January 26, 2002 9:51 PM


One of the subroutines located at this link should do the trick for you.

good luck

Posted by Aaron on January 26, 2002 10:06 PM

Re: Try using Edit>GoTo>Special>Blanks

Thanks guys! That simple trick does the job.