Sort & filter your data

You tin sort information in alphabetical and numerical order, or use filters to hide data yous don't want to come across.

Sort and Filter Your Data

To get an instance spreadsheet and follow along with the video, click "Make a Copy" below.

Brand a re-create

Sort data in alphabetical or numerical gild

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the group of cells y'all'd like to sort.
  3.  If your sheet includes a header row, freeze the get-go row.
  4. Click Data and then Sort range and then Advanced range sorting options.
  5. If your columns have titles, click Data has header row.
  6. Select the column y'all'd like to be sorted beginning and cull a sorting order.
    • To add another sorting rule, click Add another sort column.
  7. Click Sort.

Sort an entire sail

  1. On your computer, open a spreadsheet in Google Sheets.
  2. At the top, right-click the letter of the column y'all want to sort past.
  3. Click Sort sail A to Z or Sort sheet Z to A.

Sort by color

Filter your data

Of import: When yous add a filter, anyone with access to your spreadsheet will come across the filter too. Anyone with permission to edit your spreadsheet will exist able to change the filter.

  1. On your calculator, open up a spreadsheet in Google Sheets.
  2. Select a range of cells.
  3. Click Information and then Create a filter.
  4. To see filter options, become to the top of the range and click Filter Filter.
    • Filter by condition: Choose conditions or write your ain.
    • Filter by values: To hide data points, uncheck the box next to the data point and click OK.
    • Search: Search for data points past typing in the search box.
    • Filter past color:Cull which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors.
  5. To turn the filter off, click Data and then Remove filter.

Create, save, delete, or share a filter view

Important: If you only have permission to view a spreadsheet, you tin can create a temporary filter view that only you tin employ. Your filter view won't be saved.

On a computer, you tin filter information then the filtered information only applies to your view of the spreadsheet. Your filter view changes are automatically saved.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click Data and then Filter views and then Create new filter view.
  3. Sort and filter the data.
  4. To shut your filter view, at the pinnacle correct, click Shut Close.
  5. Your filter view is saved automatically.

To delete or duplicate a filter view, in tiptop right, click OptionsSettings and then Delete or Indistinguishable.

To remove all filters, go to each filter view and click Options Settingsand then Delete.

Tip: You lot can't change the society of filter views.

Come across an existing filter view

Of import: You lot can only apply one filter view at a fourth dimension.

  1. On your reckoner, open a spreadsheet in Google Sheets.
  2. Click Data and then Filter views.
  3. Select a filter view.
  4. Your filter will exist applied to the spreadsheet.
  5. To close your filter view, in the superlative right, click Close Close.

Save a filter as a filter view

Rename a filter view

  1. On your figurer, open a spreadsheet in Google Sheets.
  2. Click Data and then Filter views.
  3. Select a filter view.
  4. At the superlative left of the sheet, next to "Name", click the filter view name and type the new name.
  5. Printing Enter.

Share or transport a filter view link

  1. On your estimator, open a spreadsheet in Google Sheets.
  2. Apply the filter view .
  3. Copy the URL.
  4. Share the filter view link.

Learn more almost filters & filter views

Filters and filter views aid you lot analyze a set of data in a spreadsheet.

Yous tin can use filters to:

  • Show a specific filter when people open up your spreadsheet.
  • Sort your data later on using a filter.

You can use filter views to:

  • Save multiple filters.
  • Proper name your filter.
  • Let multiple people see different filter views at the same time.
  • Share different filters with people.
  • Brand a copy or create another view with similar rules.
  • Filter or sort a spreadsheet you lot don't have edit access to. In this case, a temporary filter view will be created.

Was this helpful?

How tin can nosotros improve it?