how to delet the blank rows in whole sheet at a time

P

pp

I have a similar problem with an import into Excel2003. from tyelly one blank
row adjusent with data
just I wish to delete only rows where both are blank.
Can i do at a time? Can someone help?
 
J

JudithJubilee

Hi PP,

If they are full blank rows:

Highlight Column A, Choose Ctrl + G + Special. Choose Blanks + OK.
Choose edit + Delete Rows.

Judith
 

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

Delete blank columns 2
Need Help Deleting Blank Rows 3
COUNT rows on external sheet if between date range 3
Match and delete rows on two different sheets from reference numbers 4
How to delete blank rows at one time in a long excel spreadsheet? 2
need to input alternate blank rows in spreadsheet 5
Hidden text in tables causes empty rows 0
VBA to automatically cut, paste entire row based on date input and delete row 0

Top