 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006autofilter help
when i set my auto filter it stops at blank lines rather than allowing me to select "blanks or non blanks" the data that it filters doesnt pass the blank line so i have dispatched arrived arrived dispatched when i set the auto filter to show "arrived" it still shows the second "dispatched" because it is after the blank line is there some setting causing this Hi Max, If you have only selected the first cell in a column or columns then applied Autofilter it will only select as far as the first blank it comes to. If you want it to select all of your data blanks included then highlight all of your data before applying Autofilter. You can also select the entire column or columns by highlighting the column headers A,B,C etc. HTH Martin thanks martin i figured it would be something simple i was missing > Hi Max, > [quoted text clipped - 10 lines] > HTH > Martin You're Welcome |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.