Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Auto filter on blank lines

I have auto filter turned on and when I filter on something there are no
longer any blank lines at the bottom of the document (it's grey). I'm not
sure what I did to get rid of them but I'd like to have them back.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Auto filter on blank lines

On Jan 28, 10:24*am, Allana McDonald <Allana
wrote:
I have auto filter turned on and when I filter on something there are no
longer any blank lines at the bottom of the document (it's grey). I'm not
sure what I did to get rid of them but I'd like to have them back.

Thanks!


Try to change the view. Menu View then Select "Normal". It sound like
you currently use "Page break preview".
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When I use Auto Filter the drop down list is blank CAF Excel Discussion (Misc queries) 0 September 17th 08 09:43 PM
Auto Filter - how to collapse "non-blank" cells in a column? marla Excel Discussion (Misc queries) 2 August 24th 08 10:03 PM
Auto insert of blank lines Robert Excel Discussion (Misc queries) 5 November 28th 07 10:32 PM
Add button to bottom of spreadsheet to delete blank lines auto GD Excel Discussion (Misc queries) 1 August 7th 07 06:07 PM
Auto Filter out text or blank rows D Hafer - TFE Excel Discussion (Misc queries) 8 July 1st 05 01:02 PM


All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"