Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Tuesday, May 05, 2015 – Permalink –

Auto Filter

Only what you want


Excel has a tool to sort lists with a number of criteria.

Select a single cell in the table and go to Data>Filter AutoFilter.
Click on the down arrow next to the field name and choose Custom.

The illustration shows how to set up a filter that displays data between two dates.

AutoFilter

Contextures.com:
AutoFilter Tips

"Some tips and techniques for working with AutoFilters, and some workarounds for problems you may encounter."

Microsoft Assistance:
All about AutoFilters Video


Jay Walkenbach:
Displaying AutoFilter criteria



"The Display Filter Criteria doesn't work well. It only works when after set the filter, the cell with the formula is selected. Then press F2 after that push the Enter key. Then it works. but the cell with the formula isn't updated automatically..."

# posted by W. van Dam : 7/06/2005


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:52 AM

Comments: Post a Comment