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

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

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

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" wrote in message
...
I need to delete n-number of empty rows in between rows with values in my
workshheet.Could u pls help me out .

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

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

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

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

Select a column with the empty rows.

F5SpecialBlanks

EditDeleteEntire Row.


Gord Dibben MS Excel MVP

On Tue, 28 Aug 2007 06:18:01 -0700, Dennis
wrote:

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