How to remove a filter in Google Sheets | Scribe

    How to remove a filter in Google Sheets

    • |
    • 0 steps |
    • 11 seconds
    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

    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
    Click "Select all"
    Click "OK" and your dataset will revert to its full view

    Remove the data filter entirely

    Click "Data"
    Click "Remove filter"
    No more filter on your dataset
    Was this Scribe helpful?
    Save this document for future reference.
    click-target-circles-background
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe