Kick off this New Year with 25% off on Kopyst Subscriptions! Use code NEWYEAR25
document-icon
How to remove a filter in Google Sheets ?
By Mitisha
|
Aug 27, 2024
|
document-icon Google
|
7 Steps
This document will guide you through the simple process of removing filters from your Google Sheets data. Whether you've accidentally applied a filter or simply want to view your entire dataset again, this tutorial will provide clear instructions on how to quickly and easily remove the filter.
document-icon
How to remove a filter in Google Sheets ?
By Mitisha
|
document-icon Google
|
7 Steps

1
2
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
Merged Image
3
Click "Select all"
Merged Image
4
Click "OK" and your dataset will revert to its full view
Merged Image
5
Click "Data"
Merged Image
6
Click "Remove Filter"
Merged Image
7
No more "Filter" on your dataset
By following these steps you can remove a filter in google sheets
Merged Image

Create your own professional guides

Start creating your own How-to guides and videos today!

App page Cta