HomeTips & TricksExcel FunctionsExcel FormulasApplied FormulasApplied FunctionsExcel MacrosBusiness UsesDownloadsExcel TestsLatest UpdatesRecent PostsAbout usQ&A

Format Pivot Table with Colours

Do you know that you can format pivot table with colours to faciliate viewing or presentation? I have always thought that pivot table is only a good analytical tool but not a good report presentation tool. This is because the results displayed is very plain with the fields colored grey and the data are all nested within lines that outline the pivot table with a white background. I was totally wrong. I found that you can actually format the pivot table to make it look professional and use it for reporting. 

The question is how? I took a fair bit of time to figure out how to format the pivot table so that the colors appears at the right place. And you don’t need to purchase tools that will help you to format the pivot tables. Here is the step by step guide to achieve a colorful professional looking report.

1. Format the entire pivot table with the right colour and font

a. Select the entire pivot table

i. Move your cursor to the top left corner of the pivot table.

ii. Click on the left mouse button.

b. Format the pivot table based on your preference

Select Entire Pivot Table

2. Format the Rows

a. Select all the values in a row area.

i. Move your cursor slight above the row name.

ii. Click on the left mouse button.

b. Format the row with your own reference

c. Repeat for the next set row values.

Select Pivot Table Rows

3. Format the Column Headers

a. Select the column headers

i. Mouse your cursor slightly above the column name

ii. Click on the left mouse button

b. Format the column header with your preference

select column data

4. Format the Data Area.

a. Select the data area.

i. Place your cursor to the left of the value on any of items in the page area.

ii. Click on the left mouse button

b. Format the Data area.

Select Data Area

5. Format the SubTotal for the rows.

a. Select the subtotals

i. Move your cursor to the left of any one of the subtotal

ii. Click on the left mouse button.

b. Format the subtotals.

highlight subtotal

With the above guide, you no longer need to pay for any solution or add-ins to format pivot table


New! Comments

Have your say about what you just read! Leave me a comment in the box below.

Share this page:

What’s this?

Enjoy this page? Please pay it forward. Here’s how…

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

<a href=””>Advanced Excel – From a Business Perspective</a><a href=””>Advanced Excel – From a Business Perspective</a>hiddensecretsbookcoverhiddensecrets_online

Excel Courses for Business Professionals

How to sleep and lose weight

Copyright © 2007 – 2019. All Rights Reserved. Privacy Policy

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. is in no way associated with Microsoft