Save for Later
This guide was created with Scribe in
11 seconds.
Sign in and create your own!
How to remove a filter in Google Sheets
Tiffany Zhao
|
0 steps
|
11 seconds
Google Sheets
1
of 2
Remove a filter for a column
Remove the data filter entirely
information ordinal icon
This Scribe shows you how to clear a filter in Google Sheets. It also shows you how to remove a data filter from your entire dataset
Remove a filter for a column
1
Your data is filtered to a smaller subset. To get the whole dataset to appear again, select the filter icon next to a column that's been filtered
Zoom Saved
2
Click "Select all"
Zoom Saved
3
Click "OK" and your dataset will revert to its full view
Zoom Saved
Remove the data filter entirely
4
Click "Data"
Zoom Saved
5
Click "Remove filter"
Zoom Saved
6
No more filter on your dataset
Zoom Saved
Was this Scribe helpful?
Save this document for future reference.
Save for Later
Have something to say?
Create an account to leave messages for the author to see!
Create an account
Feedback
This Scribe is in tip-top shape!
Leave feedback if there are any issues with this Scribe