Search all of Office.com
 
Support / Excel / Excel 2007 Help and How-to / PivotTable reports and PivotChart reports
 
 

Basics

Clear a PivotTable report or PivotChart report

Article To remove all report filters, labels, values, and formatting from a PivotTable report, and to start designing the layout all over again, use the Clear...

Create or delete a PivotTable or PivotChart report

Article Insert or delete a PivotTable or PivotChart report to summarize and analyze data in Excel 2007, and display a visual presentation of PivotTable data in a PivotChart.

Microsoft Excel Blog: A PivotTable trick that brings data validation to Excel Services

Article The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel...

Move a PivotTable report

Article You might want to move a PivotTable report so you can insert worksheet cells, rows, or columns at the current location of the report. Click the PivotTable...

Overview of PivotTable and PivotChart reports

Article Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel 2007, and become familiar with the PivotTable...

Pivot data in a PivotTable or PivotChart report

Article Rearrange or pivot the data in a PivotTable report to view it from different angles in Excel 2007.

Print a PivotTable report

Article Printing a PivotTable report the way that you want often requires using a combination of print features for worksheets and PivotTable reports. To use these...

Rename a field or item in a PivotTable or PivotChart report

Article You can quickly change the Custom Name of a field or item without displaying the Field Settings or Value Field Settings dialog boxes. The following...

Rename a PivotTable or PivotChart report

Article When you create a PivotTable or PivotChart report, Microsoft Office Excel assigns default names to each of these objects by using the following naming conventions...

Select data in a PivotTable report

Article To apply formatting, copy data, or make changes to a PivotTable report, you can select either individual cells or data regions by using commands or by using...

Take shelter in Office with Crabby's tax-time tips

Article Crabby Office Lady This column is not devoted to how you can dodge tax time; no, my goal is to help you with the taxes you have this year and to get you...

Use a PivotTable report to make external table data available in Excel Services

Article If you want to work with table data based on an external data connection in Excel Services , you can't use an external data range (also called a query...

What happened to the PivotTable and PivotChart Report command?

Article In earlier versions of Microsoft Office Excel, the PivotTable and PivotChart Report command was located on the Data menu and it started the PivotTable...

Working with different PivotTable formats in Office Excel

Article Because of the new features added to PivotTable and PivotChart reports in Microsoft Office Excel 2007 , there are now three PivotTable formats that you...