Delete blank rows - HOW?

  • Thread starter Thread starter SteveL
  • Start date Start date
S

SteveL

Have a spreadsheet that contains blank rows every other
row. How can I stip them ouyt automatically?

--Steve
 
If you don't want a VBA solution, simply highlight any column where you can
reliably say that you will happily delete every row where the cell in that
column is blank, then do Edit / Go To Special / Blanks, and then do Edit /
Delete / Entire Row.
 
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

How do I insert a row after every row of data in XL? 5
Deleting blank rows 4
Deleting Blank Rows. 3
Deleting blank rows with formulas in them 7
Deleting/removing unused rows in a worksheet 3
Having Blank Cells, etc. ? 1
Excel 2007 spreadsheet - blank rows 2
Delete Blank Rows 9

Back
Top