How To Sort And Filter Data In Google Sheets (2026)

Google Sheets can sort a list into order and filter it down to only the rows you want to see.

You can also save filter views, so different people can look at the same sheet in different ways.

These steps follow Google’s help page for Sheets on a computer.

Quick answer: sort and filter in Google Sheets

GoalWhere to click
Sort a selected rangeData, Sort range, Advanced range sorting options
Sort the whole sheetRight-click the column letter, then Sort sheet A to Z or Sort sheet Z to A
Filter a rangeData, Create a filter
Turn a filter offData, Remove filter
Make a private viewData, Create filter view

Sort a range of cells

Use this when you want to sort part of a sheet without moving the rest.

  1. Select the cells to sort.
  2. If the sheet has a header row, freeze the first row.
  3. Click Data, then Sort range, then Advanced range sorting options.
  4. Check Data has header row if your columns have titles.
  5. Choose the first column and the sort order.
  6. Click Sort.

To sort by more than one column, click Add another sort column before you click Sort.

Freezing the header first keeps it from being sorted into the data, and our guide to freezing rows and columns in Google Sheets shows how.

Sort the entire sheet by one column

  1. Right-click the column letter at the top.
  2. Click Sort sheet A to Z or Sort sheet Z to A.

This sorts every row of the sheet by the column you clicked.

Sort by color

  1. Select a range.
  2. Click Data, then Create a filter.
  3. Click the Filter icon at the top of the range.
  4. Choose a text color or fill color, and the matching cells move to the top.

Google says you can sort by conditional formatting colors, but not by alternating colors.

Create a filter

Select a range, then click Data and Create a filter, or right-click and choose Create a filter.

A filter icon appears at the top of each column in the range.

Anyone with access to the spreadsheet will see the filter, and anyone who can edit the sheet can change it.

Filter by condition, value or color

Click the Filter icon at the top of the range and choose how to filter.

Filter typeHow it works
ConditionPick a condition, or choose Custom formula is.
ValuesUncheck the values to hide, then click OK.
SearchType in the search box to find values.
ColorChoose a text color or fill color to filter by.
Single value shortcutRight-click a cell and choose Filter by cell value.

Google’s example of a custom formula is =COUNTIF(data_range, data_range)=1, which finds unique values.

Turn off a filter

Click Data, then Remove filter.

You can also right-click any cell and choose Remove filter.

Use filter views

A filter view lets you sort and filter without changing what other people see.

  1. Click Data, then Create filter view.
  2. Sort and filter the data as you like.
  3. Click Save View at the top right, then click Save.

Google says changes to a view save automatically.

If you can only view the sheet, the filter view is temporary and is not saved.

Rename, share and delete filter views

TaskHow
Find a viewClick Data, then Change view, and select one.
Rename a viewOpen it from Change view, click its name next to Name at the top left, type a new name, and press Enter.
Share a viewApply the filter view, copy the URL, and share the link.
Duplicate or deleteClick Options at the top right, then Duplicate view or Delete view.
Close a viewClick Close at the top right.

Only one filter view can be applied at a time, and you cannot change the order of your views.

Remove all filter views

Open each filter view and choose Options, then Delete view.

Add a slicer to a chart or pivot table

  1. Click the chart or pivot table you want to filter.
  2. Click Data, then Add a slicer.
  3. On the right, pick the column to filter by.
  4. Click the slicer and set a condition, or clear the checkbox for any value to hide.

Use one slicer per column, and add another slicer if you want to filter by several columns.

A slicer affects all charts and pivot tables on the sheet that use the same data set, but it does not affect formulas that use that data.

Click the slicer, open its More menu and choose Edit slicer to change its data range, column or title.

To delete one, click it and press Delete or Backspace, or choose Delete slicer from the More menu.

By default, your slicer selections are private and unsaved, and Set current filters as default in the More menu makes them visible to everyone with access.

Filters, filter views and slicers compared

ToolWho sees itWho can change it
FilterEveryone who can view the sheet.Only people who can edit.
Filter viewOnly the person applying it. Saved views can be seen and applied by anyone with access.Saving a view requires edit access, while viewers can create temporary views.
SlicerAnyone with access.Anyone with access can adjust it, but their changes stay private unless set as default.

You need edit access to add or delete slicers.

If Create a filter is unavailable

Google lists several reasons the option can be unavailable, and each has a fix.

CauseWhat to check
Merged cells or hidden rows or columnsUnmerge the cells and unhide the rows or columns.
Conditional formattingOpen Format, then Conditional formatting and look at the rules.
Data validationOpen Data, then Data validation and look at the rules.
No accessMake a copy of the sheet and check whether the option works there.

Tidy data before you sort

Duplicate rows make filtered lists harder to read, so try removing duplicates in Google Sheets first.

If you need to limit what people can type into a column, see how to create a drop-down list in Google Sheets.

To summarize the sorted data instead, read how to create a pivot table in Google Sheets.

Source

All steps come from Google’s help page, Sort and filter your data, plus Filter charts and tables with slicers.

Leave a Reply

Your email address will not be published. Required fields are marked *