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
    1. Select the entire pivot table
      1. Move your cursor to the top left corner of the pivot table.
      2. Click on the left mouse button
    2. Format the pivot table based on your preference

    Select Entire Pivot Table

  2. Format the Rows
    1. Select all the values in a row area.
      1. Move your cursor slight above the row name.
      2. Click on the left mouse button.
    2. Format the row with your own reference
    3. Repeat for the next set row values.

    Select Pivot Table Rows

  3. Format the Column Headers
    1. Select the column headers
      1. Mouse your cursor slightly above the column name
      2. Click on the left mouse button
    2. Format the column header with your preference

    select column data

  4. Format the Data Area.
    1. Select the data area.
      1. Place your cursor to the left of the value on any of items in the page area.
      2. Click on the left mouse button
    2. Format the Data area.

    Select Data Area
  5. Format the SubTotal for the rows.
    1. Select the subtotals
      1. Move your cursor to the left of any one of the subtotal
      2. Click on the left mouse button.
    2. 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.