MrExcel Publishing
Your One Stop for Excel Tips & Solutions

blanks and deleting


Posted by kim gick on November 07, 2001 8:19 AM

lets say rows 1,2,3,5,8,9,13,17 are blank is there any way besides a macro to remove/delete these rows?

thanks in advance


Posted by lenze on November 07, 2001 9:03 AM

Use autofilter and filter on a column for blanks. Then delete the filtered rows.

Posted by Anon on November 07, 2001 2:51 PM

Or ....

If you are checking/filtering one column only for blanks, then an alternative to autofilter is :-

1. Select the column
2. Go to Edit>GoTo>Special>Blanks>OK
3. Go to Edit>Delete>EntireRow>OK