10

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?

8

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.

| improve this answer | |
  • 1
    this doesn't re-sort the rows – Sam Watkins Jun 27 '16 at 13:29
  • 1
    It's not intended to resort the rows, just refresh any filters. – Morgen Jun 27 '16 at 15:04
0

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.

| improve this answer | |
-1

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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