S SteveL Feb 27, 2004 #1 Have a spreadsheet that contains blank rows every other row. How can I stip them ouyt automatically? --Steve
Have a spreadsheet that contains blank rows every other row. How can I stip them ouyt automatically? --Steve
F Frank Kabel Feb 27, 2004 #2 Hi habe a look at http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows
K Ken Wright Feb 27, 2004 #3 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.
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.
