Posted to microsoft.public.excel.misc

Gord Dibben[_2_] Gord Dibben[_2_] is offline

external usenet poster

Posts: 621

how to delete some rows without data which comes in between rows with data

Select a column then F5SpecialBlanksOK

EditDeleteEntire Rows

Gord

On Sun, 1 Apr 2012 07:58:28 +0000, sumesh56
wrote:

i have a worksheet in which there are data in some rows say in every
fifth or sixth rows. the in between rows are blank. now i want to delete
those blank rows. how can i accomplish this task in a single step?

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
delete rows if data is either	aileen	Excel Programming	3	October 8th 08 08:26 PM
Delete rows with data	AmyLynn9156	Excel Programming	3	July 10th 07 09:32 PM
How do I delete blank rows (rows alternate data, blank, data, etc	ncochrax	Excel Discussion (Misc queries)	2	June 27th 07 04:40 AM
Delete rows with no data	Mindie	Setting up and Configuration of Excel	1	November 30th 05 09:24 PM
Delete certain rows of data...	RMJ	Excel Programming	3	January 26th 04 08:30 AM

All times are GMT +1. The time now is 07:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us