Posted to microsoft.public.excel.newusers

Robert11

external usenet poster

Posts: 30

Removing Blank Rows ?

Hello:

I have a sheet with lots of blank rows.

Is there any way to compact things, and remove the blank rows all in one
shot ?

Thanks,
Bob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delte multiple blank rows in excel	Steve Dont know how George	Excel Worksheet Functions	8	October 7th 06 12:15 AM
Delete all blank rows...	bourbon84	Excel Discussion (Misc queries)	2	October 4th 06 02:13 PM
Delete ANY blank rows on worksheet	Anita	Excel Discussion (Misc queries)	7	August 31st 06 05:41 PM
Excel Novice: Delete blank rows	Kezia	Excel Discussion (Misc queries)	2	August 25th 06 04:56 PM
Listing data without blank rows	Dannycol	Excel Worksheet Functions	8	May 1st 06 06:05 PM

All times are GMT +1. The time now is 05:55 PM.

About Us

"It's about Microsoft Excel"