Customize a pivot table


Want advanced Google Workspace features for your business?

Try Google Workspace today!

You can change how your pivot table data is listed, sorted, summarized, or filtered.

Order and sort columns or rows

You can sort and order your data by pivot table row or column names or aggregated values.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the pop-up Edit button underneath the pivot table.
  3. Under "Rows" or "Columns," click the arrow under "Order" or "Sort by."

Note: To show the totals of a row or column, check Show totals.

Change how your pivot table looks

Filter data in a pivot table

You can hide data that you don’t want to show in your table.

  1. On your computer, open a spreadsheet with a pivot table.
  2. Click the pop-up Edit button underneath the pivot table.
  3. At the right, next to "Filters," click Add. Then, choose an option.
  4. Next to "Showing all items," click the Down arrow Down arrow.
  5. Choose how you want to filter:
    • Filter by condition: Write your own, or choose from the list of conditions, like if the cell is not empty, if data is less than a certain number, or if text contains a certain letter or phrase.
    • Filter by values: Uncheck the items you want to hide and click OK.

Notes

  • If you filter by value then update your source data, you'll need to update your pivot table filter if you want that data to show in the pivot table.
  • When you filter by condition, you can enter a value, a cell reference, or a field from your data. For example, if you select "Greater Than," you can enter 10, =Sheet1!A1, or =Revenue, if your data has a field called Revenue.
  • Pivot table filter settings save the list of visible values ensuring consistent filtering even if the data you filtered on is removed. Edit your filter settings to show new values.

Related articles

To learn about Spreadsheets, Databases, and Query Languages, click the button below:

Tutorial: Intro to Spreadsheets, Databases, and Query Languages

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

15088387638642595247
true
Search Help Center
true
true
true
true
true
35
false
false
Search
Clear search
Close search
Main menu
false