14

Right now it seems like the easiest way to refresh a filter view in google sheets is to remove the filter view and then apply it again. What is the fastest way to refresh a filter view in Google Sheets?

0

4 Answers 4

10

If you click the filter button in the first row of any column (it does not have to be a column that is actually filtered), then click 'OK' it will refresh the filter.

4
  • 2
    this doesn't re-sort the rows Commented Jun 27, 2016 at 13:29
  • 2
    It's not intended to resort the rows, just refresh any filters.
    – Morgen
    Commented Jun 27, 2016 at 15:04
  • Doesn't refresh sorting in the filter view. Sorting is an integral part of the feature so this answer is partial at best
    – watsonic
    Commented Aug 24, 2022 at 2:39
  • 1
    @watsonic Unfortunately, unless something has changed in the time since I wrote this, it's less a deficit in the answer than it is a deficit in Sheets ¯\_(ツ)_/¯
    – Morgen
    Commented Aug 25, 2022 at 20:07
0

Adding to Morgen's answer

If you make a change in a column and want to refresh that column's filter with the keyboard only:

Ctrl+Ctrl+Alt+RShift+TabEnter

  1. Ctrl+
    Jump to the first row (contains filter dropdown). You may need to hit more than once if there are gaps in your data
  2. Ctrl+Alt+R
    Open the filter dropmenu
  3. Shift+Tab
    Highlight the OK button.
  4. Enter
    Update the filter.
-1

Easy fix: Apply the filter to the entire column / sheet instead of just the current selection. This will automatically update all of the filters to include new additions.

0
-2

If you are trying to resort based on the existing filter after you have changed some of the sorted values, use the F5 key.

1
  • In MacOS Chrome, browser refresh doesn't work while the focus is in your sheet. One way to get around it: put the cursor in the URL bar (shortcut in MacOS Chrome: Command-L). Then you can browser refresh (in MacOS Chrome: Command-R) and it will refresh the view . Note: in other browsers or other OS's these shortcuts will be different.
    – watsonic
    Commented Aug 24, 2022 at 2:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.