In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she answers the question: how do I know if a table has been filtered? (Microsoft Excel)
Tame your computer - find the filter
If you can’t find the data you’re looking for in a worksheet, it might be hidden by a filter. When you apply a filter, entire rows are hidden if values in one or more columns don't meet the filtering criteria. There are three quick ways to see whether a filter has been applied to the sheet.
- If the button next to one of the column headings displays a funnel it means a filter has been applied. OR
- In the bottom left corner of the workbook, on the Status Bar, the number of records found is displayed or it might simply say “Filter Mode”. OR (my favourite)
- The Clear button on the Data tab has a red cross next to it.
To get rid of all of the filters in a worksheet at once click the Clear button on the Data tab. Or better still, right-click the Clear button and select Add to Quick Access Toolbar.
In future, if you want to know whether or not a table has been filtered you check whether the Clear button on the Quick Access Toolbar has a red cross and if so, you simply click it to clear all filters.
By the way, if you still cannot find the data, you might have hidden rows or columns. See tip 478 for help on how to find these.
With thanks to Ian for this week’s tip inspiration!
15 March 2018