Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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

Re: blanks and deleting

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

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

Or ....

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.