Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2011, 02:12 AM
Learner7 Learner7 is offline How to remove blank rows from a specified range? Windows XP How to remove blank rows from a specified range? Office 2007
Advanced Beginner
How to remove blank rows from a specified range?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How to remove blank rows from a specified range?

Hi,



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

Thanks.
Reply With Quote
  #2  
Old 04-19-2011, 02:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How to remove blank rows from a specified range? Windows 7 32bit How to remove blank rows from a specified range? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft