How to Create a Filter View in Google Sheets

Filter views can be useful if you want to save multiple filter views with different names for future use. This is the feature in Google Sheets, and it is not available in Microsoft Excel.

Step 1: Click the data to create the filter view;

Step 2: Click the triangle after the filter and then "Create new filter view";

Step 3: You will move to the filter view window;

Step 4: In the filter view window, filter your data, e.g., "Jackson" in Column A;

Step 5: Click the name box to change the name for future use, e.g., "Filter001-Jackson";

Step 6: Next time click the filter name and you bring the filter back.

Leave a Reply