Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

nonblank filters in excel 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
robert mills - 02 Sep 2007 22:44 GMT
how do i find nonblank filters in excel when working with spreadsheets
Max - 04 Sep 2007 06:52 GMT
> how do i find nonblank filters in excel when working with spreadsheets

Just sparing a thought here, as you haven't received any response yet (not
sure why, though <g>). ok, I don't have/know the latest xl2007, but would it
be any different from say, xl2003, where the option to choose: (NonBlanks) is
available in the autofilter dropdown (via Data > Filter > Autofilter)?
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Ron de Bruin - 04 Sep 2007 16:27 GMT
Hi Robert

When you select the whole data column and there are blanks
you see "Blanks" in the filter list when you click on the arrow in the header

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> how do i find nonblank filters in excel when working with spreadsheets
 
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.