How to Delete empty rows in excel in b/w rows with values

's Computer Specifications

I need to delete n-number of empty rows in between rows with values in my
workshheet.Could u pls help me out .

's Computer Specifications

Use Autofilter on blanks, then delete the visible rows.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dennis" <(E-Mail Removed)> wrote in message
news:4AD26099-8CC4-4D76-888C-(E-Mail Removed)...
>I need to delete n-number of empty rows in between rows with values in my
> workshheet.Could u pls help me out .

's Computer Specifications

Auto-filter for blanks. Select the rows and either right-click or Edit
menu, then "Delete rows".
--
David Biddulph

"Dennis" <(E-Mail Removed)> wrote in message
news:4AD26099-8CC4-4D76-888C-(E-Mail Removed)...
>I need to delete n-number of empty rows in between rows with values in my
> workshheet.Could u pls help me out .

's Computer Specifications

Select a column with the empty rows.

F5>Special>Blanks

Edit>Delete>Entire Row.

Gord Dibben MS Excel MVP

On Tue, 28 Aug 2007 06:18:01 -0700, Dennis <(E-Mail Removed)>
wrote:

>I need to delete n-number of empty rows in between rows with values in my
>workshheet.Could u pls help me out .

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hpw do I delete multiple empty rows found between filled rows?	Bill	Microsoft Excel Worksheet Functions	1	15th Nov 2009 12:52 AM
Excel 2003, how can I delete all empty rows	=?Utf-8?B?RWRnYXI=?=	Microsoft Excel Misc	4	26th May 2007 03:06 AM
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows	Scott	Microsoft Excel Worksheet Functions	0	13th Dec 2006 01:25 AM
[excel 2003] Delete empty rows	=?Utf-8?B?UmVkQ2VsbA==?=	Microsoft Excel Worksheet Functions	1	21st Feb 2006 11:18 AM
how do i delete empty rows in excel?	=?Utf-8?B?Y2hhcmxpZQ==?=	Microsoft Excel Misc	2	19th Jan 2005 11:45 AM