Removing Excess Blank Rows

  • Thread starter Thread starter wendy l
  • Start date Start date
W

wendy l

Is there a simple way to delete rows which are blank? I have a spreadsheet
with 4000 rows of data but some rows of data have been cleared. I would like
to delete the rows which have nothing in them to consolidate my spreadsheet.
Thank you in advance for any help provided.
 
Hi Wendy,

Press Alt F11 and then Insert | Module.

http://j-walk.com/ss/excel/tips/tip56.htm

Insert John's code into that module.

Then on your worksheet, you can go Tools | Macro | Macros and select John's
macro. That will delete your blank rows.

Incidentally, John's site is a very good site!

Hope this helps.

Best regards,
Kevin
 

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 Rows 9
automatically deleting blank rows? 3
Delete multiple rows where a blank cell is located 2
Automatically delete blank rows 4
How can I remove multiple (hundreds) of blank rows in one step? 2
Combining data from multiple rows 2
How do i insert blank rows between data that is thousands of rows 5
Removing blank columns and rows from worksheet 1

Back
Top