How to remove a filter in Google Sheets | Scribe

    How to remove a filter in Google Sheets

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

    Remove the data filter entirely

    4
    Click "Data"
    5
    Click "Remove filter"
    6
    No more filter on your dataset