- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
This chapter is from the book
This chapter is from the book
This chapter is from the book
Applying a Data Filter
When working with a large data table, it is sometimes useful to filter the table so that you can only see or work with a specific set of records. For instance, let’s say you only want to see the sales reps in Region 2. When you want to work with a subset of records, you can use Excel’s Filter. The Filter function allows you to see only those records that meet the criteria you select.
)
Click on the Filter command on the Data tab.
You will immediately see filter drop-downs inside each of your header columns. Click on the drop-down selector for the column
you want to filter.
Click the (Select All) option to clear all the check boxes, then click the check box next to the value by which you want to filter.
Click the OK button to apply the filter. Observe the funnel icon on the filtered column, indicating a filtered state.
Tip: Removing Data Filter Drop-downs
To remove the data filter drop-downs, simply go to the Data tab and select the Filter command. This clears all filters and eliminates the drop-downs from your header labels.