Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel 2010 spreadsheet that looks like this:

Department      Location     Staff
Accounting      SF           10
IT              NYC          20
Finance         NYC          15
Design          SF           20
Engineering     SF           30

(except a lot longer and wider)

I want to make it easy for others viewing this spreadsheet to apply or clear a fixed filter and see only the rows they're interested in. E.g., click to see departments in SF, or click to see departments larger than 15 staff, and see only the rows below that meet those criteria.

share|improve this question

Will AutoFilter do what you need? It basically makes every column header into a dropdown listing all the unique values in that column. Select a value to filter by it, or there's a "Custom" option for greater than/less than filters.

(What I don't know is where they've hidden this in 2007/2010. In older versions, go to Data > Filter > AutoFilter.)

Edit: in Excel 2007, click on Data, then the big funnel. The actual dropdowns have become... annoying, but they can be made to work with a few extra clicks. I assume 2010 is similar.

share|improve this answer
You also might want to consider freezing panes/rows/columns – Sathya Oct 27 '10 at 4:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .