Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page remove blank lines in between remove blank lines in between
Register FAQ Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2013, 06:38 PM
jolinchew jolinchew is offline remove blank lines in between Windows 7 32bit remove blank lines in between Office 2010 32bit
Novice
remove blank lines in between 		 
Join Date: Jul 2013
Posts: 11
jolinchew is on a distinguished road
Default remove blank lines in between
I have more than 20000 lines in one excel, including some blank lines, i want to remove those blank lines, any way? thanks
Attached Images
File Type: png excel_blank.PNG (74.5 KB, 7 views)
Reply With Quote
  #2  
Old 07-31-2013, 12:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,715
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default
Use the filter to filter on blank rows then delete the resulting rows
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 07-31-2013, 09:11 AM
BobBridges's Avatar
BobBridges BobBridges is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 32bit
Expert
  
Join Date: May 2013
Location: USA
Posts: 699
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default
Or just sort them. I don't use filters much, so I usually think of sorting the lines first.
Reply With Quote
  #4  
Old 08-01-2013, 04:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,715
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default
Quote:
Originally Posted by BobBridges View Post
Or just sort them. I don't use filters much, so I usually think of sorting the lines first.

If some cells contain non printable characters or spaces, etc... sorting can give some odd results...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 08-01-2013, 06:09 AM
BobBridges's Avatar
BobBridges BobBridges is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 32bit
Expert
  
Join Date: May 2013
Location: USA
Posts: 699
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default
Hm, you're probably right. And really filters are probably better. I should get used to them.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove blank lines in between Macro to remove blank column netchie Word VBA 4 03-14-2013 02:22 PM
remove blank lines in between Getting blank lines instead of supressed lines. Welshie82 Mail Merge 2 11-14-2011 01:41 AM
remove blank lines in between Blank lines in standard letters AlteDäne Mail Merge 5 06-29-2011 05:32 PM
remove blank lines in between How to remove blank rows from a specified range? Learner7 Excel 1 04-19-2011 02:45 AM
remove blank lines in between 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 05:11 PM.

Contact Us - Privacy Statement - Top

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