#1
|
|||
|
|||
How to remove blank rows from a specified range?
Hi,
How to remove blank rows from a specified range of cells using formula? Thanks. |
#2
|
||||
|
||||
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 |