How to remove blank rows from a specified range?

Learner7 · #1 04-19-2011, 02:12 AM

Hi,

How to remove blank rows from a specified range of cells using formula?

Thanks.

Colin Legg · #2 04-19-2011, 02:45 AM

Hi,

You cannot remove blank rows using a formula.

You have to perform one of the following actions:
(1) Delete the blank rows (for example, via filtering); or
(2) Sort the column (this will "push" the blank rows to the bottom).

Both of these options can be automated using VBA if necessary.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help on Macro 03- Find text - if text is blank then remove line	simpleonline1234	Word VBA	1	02-25-2011 02:28 AM
Rows to Columns	kyakobi	Excel	5	12-07-2010 03:12 PM
Average of many rows	speedycorn1	Excel	1	10-30-2010 07:54 PM
How do I turn the top 2 rows into a header	GR8Fandini	Excel	1	02-06-2010 12:58 PM
How to turn all blank lines into non-blank for legal forms	sieler	Word	3	04-12-2009 01:38 PM