The Google Drive team has announced some new features and updates that have been added to the Google Sheets spreadsheet app. The updates focus on filter and view options for spreadsheets. Headlining the changes is the ability to create a “temporary filter view” on spreadsheets for which users only have read access permissions. Using the temporary filter, users can filter and sort data in those spreadsheets.
Google also added some features that will make it easier to share spreadsheet data with other users. First, a specific view can be shared so that recipients don’t have to go through a long list to figure out what it is you are wanting them to look at. This can be achieved just by copying and pasting a URL. Second, Google added the ability tothe range that is used to define a filter view. Previously, to change the range users would have to delete the existing range and then create a new one.
source: +Google Drive