Pivot Table Excel 2007. Under choose where you want the pivottable report to be placed select new worksheet to place the pivottable in a new worksheet or existing worksheet and then select the location you want the pivottable to appear. In table range verify the cell range.
You can enter your data range manually or quickly select it by dragging the mouse cursor across all cells in the range including the labeled column headers. Select the options tab from the toolbar at the top of the screen. A pivot table is an interactive table that lets you group and summarize data in a concise tabular format.
You can also use an excel table as the source for a pivot table and new data will automatically be included in the pivot table.
Pivot tables also let you play around with the arrangement of the summarized data. Before we get started we first want to show you the data for the pivot table. To create a pivot table click the insert tab and then click the pivottable icon on the toolbar. In table range verify the cell range.
