back to gallery
how to create a pivot table in google sheets
5 steps
1
Open Your Google Sheets Document
Navigate to **Google Sheets** and open the document containing the data you want to analyze.
2
Select Your Data Range
Click and drag to highlight the range of cells that contains your data. Ensure you include all relevant columns and rows.
3
Insert a Pivot Table
Go to the menu and click on **Data**, then select **Pivot table**. Choose whether to place the pivot table in a new sheet or in the existing sheet.
4
Add Rows and Columns
In the Pivot table editor on the right, click on **Add** next to **Rows** and **Columns**. Select the fields you want to analyze.
5
Add Values and Filters
Click on **Add** next to **Values** to include the data you want to summarize. Optionally, you can add filters to narrow down your data.
Documents you might like
Copyright © 2024 Notta. All Rights Reserved.