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.
Is there any way to do this?