
By filtering data, you can view only the information that's important. This is really helpful when you're working in huge spreadsheets.
Filter Data
- Select a cell within a data range.
- Click Data on the menu bar.
- Select Create a filter.
A filter button is added to each column header.
- Click the filter arrow for a column.
- Specify the items you want to filter.
- Click OK.
The data within the range is filtered based on the criteria you selected.
Advanced Filters
You can also set up advanced filters that filter data by specific conditions. For example, you can filter data so that only values that are greater than a certain amount will appear.
- Click the filter arrow for a column.
- Click Filter by condition.
- Click the condition list arrow.
- Select a condition.
- Set that condition's value.
- Click OK.
The data is filtered and only shows the values that meet the conditions you specified.
Clear a Filter
If you no longer need the filter, clear it to see all of the data again.
- Click Data on the menu bar.
- Select Turn off filter.
The filter is removed, and you can see all the cells in the data range again.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.