delete blank rows

S

steve

What is an expedient way to search an excel worksheet,
find and delete blank rolls withouthaving to manually
scroll through the blank rows.
 
B

Bob Umlas

If the sequence of the rows doesn't matter, you can sort them -- all blanks
will go to the bottom and can be deleted in bulk. If the sequence IS
important, then enter 1 in an unused column at the top row, then 2 in the
cell below, and using the fill-handle, drag down to the bottom row of data.
So now you have "numbered" your data. Sort as before, delete the blank rows,
resort by the "new" column & clear the column -- all should be OK now.
Bob Umlas
Excel MVP
 

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

Similar Threads

MS Word normal.dot cannot be fixed 'text box' appears each time 4
Dealing with a Pivot Table (when I don't want to) 0
Macro to select and delete levels of a document 2
Hide columns based on row values 2
Select Text to End of Footnote 9
Indenting every other paragraph in Word at the same time? 0
Code to cut a paragraph that's followed by a table 2
Copy text into blank rows 2

Top