deleting blank rows

  • Thread starter Thread starter pk
  • Start date Start date
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
 
Select a column.

F5>Special>Blanks>OK

Edit>Delete>Entire Row.

Gord Dibben Excel MVP
 
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...
 
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...
 
You must log in or register to reply here.

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

COUNT rows on external sheet if between date range 3
Eliminating blank rows 3
Lookup Formula 4
how to delet the blank rows in whole sheet at a time 1
Need Help Deleting Blank Rows 3
Deleting Rows Between Empty Cells 6
need to input alternate blank rows in spreadsheet 5
how can I insert a blank row after each subtotal in a worksheet 9

Back
Top