Filter Google Sheets Data without Changing What Collaborators See

Google Sheets Logo

Filters in Google Sheets let you analyze data in your document by showing only the things you want. However, it changes how others see the document, too. Here’s how to use filter views to leave each collaborator’s view unchanged.

Fire up Google Sheets and open up a spreadsheet to get started.

Example of a dataset in Google Sheets.

Click Data > Filter Views > Create New Filter View.

Click Data > Filter Views > Create New Filter view.

The row numbers and column letters will turn a dark gray color when activated. At this time, you should give your filter view a name to distinguish it from any other views you make in the future and check the range is correct. You can always edit both of these later if needed.

Rename the view to something memorable and make sure the range is correct.

For this guide, we want to filter anything in the table that has a price per unit greater than $10. Click the filter icon in the field for “Price Per Unit.”

Read the remaining 21 paragraphs

Read more

%d bloggers like this: