top of page

You are learning Sorting and Filtering in MS Excel

How to create custom filter views in Excel?

While Excel doesn't have a specific "create custom filter views" option, you can achieve a similar outcome by saving specific filter criteria as a named view. Here's how:

1. Apply your desired filters: Use the filtering options (AutoFilter arrows, custom criteria) to get your data narrowed down to the exact view you want to save.
2. Go to View > Workbook Views: Navigate to the "View" tab and locate the "Workbook Views" section.
3. Click "Custom Views" > "Add": Within "Workbook Views," click on "Custom Views" and then select "Add" from the dropdown menu.
4. Name your view: In the "Name" box, type a clear and descriptive name for your custom view. This will help you easily identify it later.
5. Choose what to include (Optional): Under "Include in view," you can check or uncheck boxes to specify which settings you want to save with this view. By default, all current settings (including filter criteria) are included.
6. Click "OK": Once you're happy with the view name and included settings, click "OK" to save your custom view.

Now, whenever you want to return to this specific filtered data view, you can simply:

1. Go to View > Workbook Views: Navigate to the "View" tab and locate the "Workbook Views" section.
2. Click "Custom Views" > Select your view: Within "Custom Views," click on it to display the view you previously saved with your desired filter criteria.

This way, you can create and manage multiple custom views with different filter combinations, allowing you to quickly switch between various filtered data presentations within your workbook.

bottom of page