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.

Here are the steps to Format Pivot Tables in Google Sheets

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

In this example we will use the below 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

Format->Theme

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