Re: Excel Question: How to Delete All Blank Rows from a worksheet?
From: Tim Zych (tzych_at_noworms_earthlink.net)
Date: 04/13/04
- Next message: Frank Kabel: "Re: Lookup Match"
- Previous message: tojo107: "Lookup Match"
- In reply to: DaveThePianoGuy: "Excel Question: How to Delete All Blank Rows from a worksheet?"
- Next in thread: Dave Peterson: "Re: Excel Question: How to Delete All Blank Rows from a worksheet?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Apr 2004 06:45:05 -0700
Select the column, Edit menu ->
Goto -> Special... -> Blanks -> OK -> Edit -> Delete (shift cells up) -> OK.
"DaveThePianoGuy >" <<DaveThePianoGuy.14nfqy@excelforum-nospam.com> wrote in
message news:DaveThePianoGuy.14nfqy@excelforum-nospam.com...
> 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.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
- Next message: Frank Kabel: "Re: Lookup Match"
- Previous message: tojo107: "Lookup Match"
- In reply to: DaveThePianoGuy: "Excel Question: How to Delete All Blank Rows from a worksheet?"
- Next in thread: Dave Peterson: "Re: Excel Question: How to Delete All Blank Rows from a worksheet?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
