If you're like most Excel users, you probably use the filter feature quite often. Filtering is a great way to quickly find the data you need in a large worksheet. But did you know that there's a shortcut that can save you even more time when filtering data in Excel?
The next time you need to filter data in Excel, try this shortcut:
1. Select the data you want to filter.
2. On the Home tab, in the Editing group, click Sort & Filter.
3. Click Filter.
4. Click the arrow next to the column you want to filter, and then click the filter criteria you want to apply.
This shortcut will save you a few clicks every time you need to filter data in Excel. Give it a try the next time you need to filter data in a worksheet!