|
|
#2
07-31-2013, 12:33 AM
|
||||
|
||||
Use the filter to filter on blank rows then delete the resulting rows
__________________
Using O365 v2407 - 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 
|
|
#3
07-31-2013, 09:11 AM
|
||||
|
||||
|
Or just sort them. I don't use filters much, so I usually think of sorting the lines first.
|
|
#4
08-01-2013, 04:44 AM
|
||||
|
||||
|
Quote:
If some cells contain non printable characters or spaces, etc... sorting can give some odd results...
__________________
Using O365 v2407 - 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
|
|
#5
08-01-2013, 06:09 AM
|
||||
|
||||
|
Hm, you're probably right. And really filters are probably better. I should get used to them.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro to remove blank column
|
netchie | Word VBA | 4 | 03-14-2013 02:22 PM |
|
Getting blank lines instead of supressed lines.
|
Welshie82 | Mail Merge | 2 | 11-14-2011 01:41 AM |
|
Blank lines in standard letters
|
AlteDäne | Mail Merge | 5 | 06-29-2011 05:32 PM |
|
How to remove blank rows from a specified range?
|
Learner7 | Excel | 1 | 04-19-2011 02:45 AM |
|
How to turn all blank lines into non-blank for legal forms
|
sieler | Word | 3 | 04-12-2009 01:38 PM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
