The Ribbon “Design”

In “Excel 2007”, almost all menus and toolbars are replaced by the “Ribbon”.
“Excel 2007” has two ribbons that are used only for pivot tables.
The Ribbon “Options” and the Ribbon “Design”.

The Ribbon “Design” , as the name suggests, is used for the layout of our “PivotTable”.

All these features speak for themselves, so I will go through them quickly from left to right.

Far left we find the “Subtotals”.
When we click on it, it unfolds a menu with three choices:

1. “Do not show subtotals”,
2. “Show all subtotals at the bottom of group” and
3. “Show all subtotals at top of the group”.

I think this is clear.

We also have the “Grand Totals” button.
When we click on it, it unfolds a menu with four choices.
These all seem to be clear.

Next is the “Report layout” button.
When we click on it, it unfolds a menu with three choices:

1. “Show in Compact form”: This view provides the most compact representation of the PivotTable. This can restrict its usefulness if you want to print a large “PivotTable” on a page.
2. “Show in Outline form”: This view shows our PivotTable as an overview. Cell borders are not shown.
3. “Show in Tabular form”: When you use this view, displays all data in a table format and you copy cells easily to another worksheet.

The next button is “Blank Rows” – has two options and both are clear.

The following four check boxes seem to be obvious.
-“Row headers” and “Column headers” are in bold.
“Banded rows” and “Banded columns” seem to be quite clear. I must tell you this, when you use it, especially with the banded rows, the data in the PivotTable is clear to read.

And then we finally “PivotTable styles”.
Again we have the Live Preview option, which is quite handy.
We will see more about “PivotTable styles” in Lesson 53

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats