Notta
Showcase

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

lighting effect

Start creating your guide online

Automate guide creations and save your time into things that matter.

Notta
Showcase
Copyright © 2024 Notta. All Rights Reserved.