How to Format Pivot Tables in Google Sheets(Quick & Easy Guide)

In this tutorial you will learn How to Format Pivot Tables in Google Sheets.

Format Pivot Tables in Google Sheets(Quick Overview of Steps)

  • Open Google Sheets
  • Prepare your dataset
  • Create A Pivot table for the dataset
  • Customize the default Pivot table theme
    • To Customize the theme ,click on the Format menu on the Main toolbar .
    • Under Format Menu Select Theme option from the drop-down.
    • Choose a theme from a list of readymade theme templates or choose customize option
  • Add a border and center the text under Pivot table

Pivot table helps a user to summarize a large amount of dataset with few simple clicks .

If you don’t like the default formatting of the Pivot Table in Google Sheets.You can easily customize it as per your preference

Let’s go through the previously mentioned quick steps in detail.

How to Format Pivot Tables in Google Sheets : Step by Step Guide

Here are the steps to Format Pivot Tables in Google Sheets

Step 1 : Open Google Sheets

Step 2 : Prepare your dataset

Open en existing google sheet with Pivot table or create a new google Sheet with required data set

How to Create Pivot Table in Excel
How to Create Pivot Table in Excel

In this example we will use the below dataset

Step 3 : Create A Pivot table for the dataset

Now we will create a Pivot table for our dataset.

  • Click on any cell within the data set and press CTRL+A to select and highlight the entire dataset .
  • Now Click on the Insert menu and Select Pivot table from the drop-down

Specify the Pivot table destination where you want to insert the Pivot table either new sheet or existing Sheet and Click on Create button .

Go to the newly generated Pivot Table Sheet and navigate to the Pivot table editor on the right hand side of your Sheet.

Add rows,columns and Values on the Chart editor as per your dataset

In this example we have added division and sub division to the Rows and number of units ,price per unit to to values (as columns)

It will create a Pivot Table which looks like below screenshot

Step 4 : Customize the default Pivot table theme

  • To Customize the theme ,click on the Format menu on the Main toolbar .
  • Under Format Menu Select Theme option from the drop-down.

Format->Theme

How to Format Pivot Tables in Google Sheets
  • Once you click on Format ->Theme ,a new Theme window will pop-up on the top right corner of your Google Sheets.
  • You can either choose a theme from a set of ready made themes provided by google sheets or click on Customize button to select you own custom theme colors

We have selected the Energetic theme for this example.

Step 5 : Add a border and center the text under Pivot table

Now we will highlight the dataset and a include a border across every cell in the Pivot table.

How to Format Pivot Tables in Google Sheets(Conclusion)

In the above tutorial we have shown you a step by step guide using which you can to Format Pivot Tables in Google Sheets

We hope this tutorial on How to Format Pivot Tables in Google Sheetswas useful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )