Removing Excess Blank Rows

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.
 
K

Kevin Stecyk

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
 
Top