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.
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.
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.”
Post a Comment Blogger Facebook
We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.