Microsoft Office Tutorials and References
In Depth Information
Lesson 15: Programming PivotTables
If you select a single cell anywhere in the list, such as cell E7, which is selected in Figure 15-2,
you can create a PivotTable by selecting the Insert tab and clicking the PivotTable icon. The
Create PivotTable dialog box will appear, with the Table Range field already filled in, as shown in
Figure 15-3. I chose to keep the PivotTable on the same worksheet as the source data, and for the
PivotTable’s top-left corner to occupy cell H4.
When locating a PivotTable on the same worksheet alongside the source table,
it’s best to have at least one empty column between the source table and
your PivotTable. It’s also a good idea to leave a few empty rows above the
PivotTable to leave room for the Report Filter area (what was called the Page
Area in version 2003).