Skip to search results
PRODUCT
Office.com results
Display or hide items in a PivotTable or PivotChart field
Article Hiding an item in a row field or column field removes it from the report, but the item still appears in the dropdown list for the field. Hiding an item in a...
Excel 2003
Ways to customize PivotTable reports
Article You can customize the appearance and content of a PivotTable report to get the presentation you need. In a new report, first display the data you want to see, a...
Excel 2003
Show or hide field buttons in a PivotChart report
Article Hiding the field buttons also hides the page field drop area , if your report doesn't have any page fields . Click the PivotChart report. On the PivotTable...
Excel 2003
Change the layout of a PivotChart report
Article Decide whether to make the layout changes on the screen or in the wizard. Usually you can make changes on the screen. If changes result in long delays in retrie...
Excel 2003
Rename a field or item in a PivotChart report
Article Rename a field Double-click the field button for the field you want to rename. In the PivotTable Field dialog box, type a new name in the Name box. Rename...
Excel 2003
Select data in a PivotTable report
Article When you apply formatting or change calculated item formulas in a PivotTable report , you can select either individual cells or sections of the report. Chang...
Excel 2003
Sort a PivotTable or PivotChart report
Article Microsoft Excel uses the following order for ascending sort: numbers, text, logical values, error values such as #REF! and #VALUE!, and then blank cells. Descen...
Excel 2003
Display a different page in a PivotTable or PivotChart page field
Article Click the arrow in the cell with the item currently displayed in the page field. Do one of t he following: Select a single item   Click the item you want. In...
Excel 2003
Change the amount of detail displayed in a PivotTable report
Article Determine what kind of source data your report has: click the report, if the field list is not displayed click Show Field List on the PivotTable toolbar,...
Excel 2003
Change the amount of detail displayed in a PivotChart report
Article Determine what kind of source data your report has: click the report, if the field list is not displayed click Show Field List on the PivotTable toolbar...
Excel 2003
Change the layout of a PivotTable report
Article Click the report. If you have multiple page fields , arrange them in rows or columns. How? On the PivotTable toolbar , click PivotTable , and then click T...
Excel 2003
Rename a PivotTable field or item
Article Click the field or item you want to rename. Type a new name. Press ENTER. Notes If you hide and then redisplay levels in PivotTable reports based on ...
Excel 2003
Format a PivotTable report
Article Do one or more of the following: Apply indented or nonindented format Click the report. On the PivotTable toolbar, click Format Report . Do one of the foll...
Excel 2003
Group items in a PivotTable or PivotChart field
Article If the field is a page field , check the page field settings, and then move it temporarily to the row or column area. How? For a PivotChart report, work in the...
Excel 2003
Didn't find what you were looking for?Search all of Office.com