Deleting empty rows

F

Felix

How can I easily delete empty rows on a huge worksheet (other than sorting)?
(Excel 2007)

Felix
 
M

Muhammed Rafeek M

Use filter. Or Select blank rows by using Edit->Goto->Special->Blanks, option
and delete
 

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

Shared Link is showing empty notebook 1
Macro to select and delete levels of a document 2
Cell data entering slow! 0
Sort doesn't always work 1
Repeating a row other than the 1st row as the header row in a table from next page 1
Copy addition formula of non-consecutive horizontal cells 2
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Delete empty rows 1

Top