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.
Format the entire pivot table with the right colour and font
Select the entire pivot table
Move your cursor to the top left corner of the pivot table.
Click on the left mouse button
Format the pivot table based on your preference
Format the Rows
Select all the values in a row area.
Move your cursor slight above the row name.
Click on the left mouse button.
Format the row with your own reference
Repeat for the next set row values.
Format the Column Headers
Select the column headers
Mouse your cursor slightly above the column name
Click on the left mouse button
Format the column header with your preference
Format the Data Area.
Select the data area.
Place your cursor to the left of the value on any of items in the page area.
Click on the left mouse button
Format the Data area.
Format the SubTotal for the rows.
Select the subtotals
Move your cursor to the left of any one of the subtotal
Click on the left mouse button.
Format the subtotals
With the above guide, you no longer need to pay for any solution or add-ins to format pivot table
