documentation
.HELP!
Office PivotTable Documentation
Show or hide the toolbar of the PivotTable list
Office PivotTable
previous page
next page
Show or hide the toolbar of the PivotTable list
Right-click the PivotTable list, and then click
Commands and Options
.
Click the
Behavior
tab.
Select or clear the
Toolbar
check box.
previous page
start
next page
Menu
Homepage
Table of contents
Getting Started
About PivotTable lists
About working with PivotTable lists in different browsers
About Microsoft Office Web Components
About View-only mode for Office Web Components
About designing PivotTable lists
Save changes to a PivotTable list
Undo changes to a PivotTable list
Print a PivotTable list
Elements of a PivotTable list
Select a PivotTable list or its elements
About viewing a chart based on a PivotTable list
Change title, captions, and labels
View information about a field or item
Microsoft Office PivotTable Component Accessibility
Keyboard shortcuts in PivotTable lists
Using PivotTable List Tools
About the toolbar, field list, and Commands and Options dialog box
Show or hide the toolbar of the PivotTable list
Show or hide the title bar of the PivotTable list
Show or hide the field list of the PivotTable list
Show or hide the Commands and Options dialog box
Show or hide drop areas
Adding and Removing Fields
About adding and removing fields
Add or remove a field
Changing the Layout
About changing the layout of a PivotTable list
Move a field or column
Set the size of a PivotTable list and its elements
Displaying Data
About displaying totals in a PivotTable list
Summary functions available in a PivotTable list
Show or hide totals for a field
Customize a total field
Include or exclude hidden data when calculating totals
Edit a calculated field
About hyperlinks
Show data as hyperlinks
Show or hide ScreenTips
Displaying Details and Items
About displaying details and items
Show or hide expand indicators next to items
Show or hide detail data for an item or field
Show or hide items
Show or hide items that have no data
Automatically show all detail data
Automatically show all items
Add, edit, or delete data
About item properties
Show or hide item properties
Specify the display order of item properties
Formatting a PivotTable List
About formatting a PivotTable list to improve appearance or readability
Format a PivotTable list and its elements
Format the contents of a PivotTable list to read right to left or left to right
Number formats for PivotTable lists
Sorting and Grouping Data
About sorting data
Sort data in a field
Remove sort order
About grouping items
Group or ungroup items
Filtering Data
About finding data
Filter a field to display only the data you want
Remove filters to display all data in a PivotTable list
Allow multiple selection in the filter area
Refreshing Data
Refresh a PivotTable list with updated source data
Using PivotTable Lists in Other Programs
About exporting a PivotTable list to Excel or other applications
Export or copy a PivotTable list to Excel or other applications
Troubleshoot PivotTable Lists
Troubleshoot PivotTable lists
Get in touch
Submit feedback about this site to:
[email protected]