deleting blank rows

P

pk

I imported a report from another application. I cleaned
up the report but have blank rows between the data. Is
there a way to delete the blank rows at once? Thanks
 
G

Gord Dibben

Select a column.

F5>Special>Blanks>OK

Edit>Delete>Entire Row.

Gord Dibben Excel MVP
 
K

KEvin Pyle

Thank you, Gord. I was looking for this very solution also.
-----Original Message-----
Select a column.

F5>Special>Blanks>OK

Edit>Delete>Entire Row.

Gord Dibben Excel MVP
Click to expand...
 
K

KEvin Pyle

Thank you, Gord. I was looking for this very solution also.
-----Original Message-----
Select a column.

F5>Special>Blanks>OK

Edit>Delete>Entire Row.

Gord Dibben Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Word 2007 flash screen upside down and Word2007 cannot be used 0
Code to cut a paragraph that's followed by a table 2
Macro to select and delete levels of a document 2
Need Help with a VBA subroutine 0
Indenting every other paragraph in Word at the same time? 0
Repeating a row other than the 1st row as the header row in a table from next page 1

Top