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

"Lisa J. Stamper" wrote:

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?