Sort and filter data on view-only spreadsheets with Filter Views

Ever need to filter or sort data on a spreadsheet that you can't edit? For example, maybe you're looking at sales data on a team-wide spreadsheet that only one owner can edit, but you only want to see items that you're responsible for. Now you can by creating a "temporary filter view"  from the toolbar or Data menu in the new Google Sheets (

There are a few other improvements we made based on your feedback, too:
- Share a link to a specific view so people don't have to dig through the list to find the one you want them to look at. Just copy/paste the URL.
- Ability  to change the range that's used for a filter view so you don't have to delete and re-create it.
Shared publiclyView activity