I would like to make a filter on Google Sheet but exclude one column

For example:

screen shot

In this case I would like to have the filter on Column A and B but the data on Column B should stay as they are, so when I sort A and C, B's data doesn't move.


There is a couple of ways in which you could do what you want:

  • use a re-arrange your spreadsheet so that the columns you want filtered are contiguous, create a filter view and customize the range for the columns that you want filtered
  • use a query function that would filter your selection on another region (for example: query(Sheet1!A1:X15,"select A,B,C,D,H,I,J where A = 'Reagan' ",1)

I think that in-place non-continuous-region in-place filtering is not possible in Google Sheets.


Green and black filter views cannot be created with skipping columns if you wish for column overall dependency when you filter stuff. Rearranging column beforehand of creating filter views is your best option. Alternatives include giving up on filter views and filter it via formulae like QUERY and FILTER.

=FILTER({Sheet1!A:A, Sheet1!C:C}, Sheet1!A:A=D1)

=QUERY({Sheet1!A:A, Sheet1!C:C}, "where Col1='"&D1&"'", 0)

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.