In Excel I have a workbook, and want to select all blank rows for.

H

HANDY ANDY

I have a worksheet with around 19,000 rows, some of which are blank. It's a
price list I do regularly. How can I select all blank rows and then delete
them. It will take hours to do them all manually.
 
G

Gord Dibben

If a blank in any column means the entire row is blank, you can select column
A and.....

Edit>Go To>Special>Blanks>OK.

Edit>Delete>Entire Row.

Gord Dibben Excel MVP

On Fri, 15 Oct 2004 08:17:06 -0700, "HANDY ANDY" <HANDY
 
Top