delete blank rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel spreadsheet sent to me that contains blank rows. Is there a
way to get rid of the blank rows with a formula so I don't have to go through
and delete. There are over 2000 rows with blanks inbetween each row of text.

Thanks,
 
If you set up Autofilters then you can filter one column for (blanks),
then highlight all the blank rows which are displayed (row identifier
turns blue) and Edit | Delete Row in one operation. Select (All) from
the filter pull-down list and all your blank rows will have gone.

Hope this helps.

Pete
 

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

Deleting blank rows 4
automatically deleting blank rows? 3
Deleting Blank Rows. 3
Deleting blank rows with formulas in them 7
Having Blank Cells, etc. ? 1
How do i insert blank rows between data that is thousands of rows 5
How To Have A Cell Be Blank If... 2
Deleting/removing unused rows in a worksheet 3

Back
Top