Manage Filter View Options in Google Sheets

How to manage filter view options in Google Spreadsheet?

Explanation

Filter view options:
There are four options available to manage the filter view,
1: Rename
2: Update Range
3: Duplicate
4: Delete
Use any one of the following options, to manage the filter view.
Option 1: Click Data Filter views Filter view options choose the option.
filter view options google sheets1
Option 2: Click the arrow near the filter icon Filter view options choose the option.
filter view options google sheets
Option 3: Click the settings icon and choose any of the options.
filter view options google sheets2
Rename Option:
To rename the filter view,
Step 1: Choose any of the above said options to select "Rename". Here, we have chosen Settings Rename.
filter view options rename google sheets1
Step 2: Cursor will highlight the filter name field to change the name. Type the name and press "Enter".
filter view options rename google sheets
Update Range:
To update the selected filter range,
Step 1: Settings icon Update Range.
filter view options range google sheets1
Step 2: Type the range of the cells and press "Enter".
filter view options range google sheets
Duplicate:
To make a duplicate copy of the filter view,
Step 1: Settings icon Duplicate.
filter view options duplicate google sheets
Step 2: Duplicate copy of the filter view will be created with the name "Copy of..".
filter view options duplicate google sheets1
Step 3: You can choose the filters from the list under Filter option as shown below,
filter view options duplicate google sheets2
Delete:
To delete the filter view created,
Step 1: Click settings icon and select "Delete".
filter view options delete google sheets
Step 2: Created filter view will be deleted and removed from the list.
filter view options delete google sheets1
Close:
To close or hide the filter view,
Option 1: Click the Close icon.
filter view options close google sheets
Option 2: Select "None" from the filter list.
filter view options close1 google sheets
Filter view will be closed and normal view will be enabled.


Related Topics

Google Docs Spreadsheet Tutorial