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

L

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?
 
N

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

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?
 

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

Top