Excel Question: How to Delete All Blank Rows from a worksheet?

[DaveThePianoGuy]

Hi, I'm brand new, and that is my question. I just spent 2 hour
laboriously mousing along deleting row by row, every other row thinkin
there's gotta be a better way. (I could've done it of course if the
were adjacent, but they were interspersed with my good data). I'm
little behind the times: agile with keystrokes but less so with mous
[think I was quicker in Lotus DOS! (actually "TWIN")]. But I do play
mean piano

 

[JMay]

Check out:
http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

 

[Tim Zych]

Select the column, Edit menu ->
Goto -> Special... -> Blanks -> OK -> Edit -> Delete (shift cells up) -> OK.

 

[Dave Peterson]

A non-macro approach.

Insert an extra column.

Put =row() in the first row and drag down.
copy that column and edit|paste special|values

Sort your data to get those blanks together.
Delete them in one fell swoop.

Use that helper column to put things back in the same order that you started.
delete that helper column.

Hi, I'm brand new, and that is my question. I just spent 2 hours
laboriously mousing along deleting row by row, every other row thinking
there's gotta be a better way. (I could've done it of course if they
were adjacent, but they were interspersed with my good data). I'm a
little behind the times: agile with keystrokes but less so with mouse
[think I was quicker in Lotus DOS! (actually "TWIN")]. But I do play a
mean piano.