How can I remove multiple (hundreds) of blank rows in one step?

[Lisa J. Stamper]

I have a large spreadsheet that I inherited at work. It has hundreds of
blanks rows between data I would like to sort. Is there an easier way to
remove empty rows and columns other than to just click and delete? Is there
a way to get Excel to select all blank rows or columns so then I could delete
them?

 

[nastech]

Try: hilite column that has nothing but empty cells in column (you don't
want) clicking on Menu item Data, Filter, Auto Filter, custom, equals nothing
(empty box), if not already know: hilite all rows with mouse, delete key, or
right-click / delete

 

[R. Choate]

Select the range you want to do this on. Hit the "F5" key. Click on the "special" button. choose the "blanks" radio button and click
OK. Then just delete those rows, either with the click on the delete rows icon or you can use the menu. Piece of cake.
--
RMC,CPA


I have a large spreadsheet that I inherited at work. It has hundreds of
blanks rows between data I would like to sort. Is there an easier way to
remove empty rows and columns other than to just click and delete? Is there
a way to get Excel to select all blank rows or columns so then I could delete
them?