documentation
.HELP!
Office PivotTable Documentation
Show or hide the field list
Office PivotTable
previous page
next page
Show or hide the field list
In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
Click
Field List
on the
toolbar
.
previous page
start
next page
Menu
Homepage
Table of contents
Getting Started
About PivotTable lists
Browsers that support PivotTable lists
About Microsoft Office Web Components
About installing, licensing, and distributing Office Web Components
About View-only mode for Office Web Components
Getting Help
About getting help
Microsoft Office PivotTable Component Accessibility
Keyboard shortcuts
Using PivotTable List Tools
About the toolbar, field list, and Commands and Options dialog box
Show or hide the toolbar
Show or hide the field list
Show or hide the Commands and Options dialog box
Show or hide the title bar
Show or hide drop areas
Designing PivotTable Lists
Applications that you can use to design or modify a PivotTable list
About PivotTable list source data
About making connections to external data sources more secure
About accessing a data source on a different domain
Add data to a PivotTable list
Elements of a PivotTable list
Select an element of a PivotTable list
View information about a field or item
Create a PivotTable list
Save changes to a PivotTable list
Print a PivotTable list
Remove a PivotTable list from a Web page
About creating a chart based on a PivotTable list
Create a chart based on a PivotTable list
About using a PivotTable list in a browser
About restricting the use of a PivotTable list in the browser
Restrict the use of a PivotTable list in the browser
Change title, captions, and labels
About providing custom instructions for a PivotTable list
Adding and Removing Fields
About adding and removing fields
Add or remove a field
Changing the Layout
About customizing the layout of a PivotTable list
Move a field or column
Set the size of a PivotTable list and its elements
Displaying Data
About calculating totals
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
Show or hide expand indicators next to items
About displaying details and 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 detail 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 and its elements
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 PivotTable list
Remove sort order
About grouping items
Group or ungroup items
Filtering Data
About filtering data in a PivotTable list
Filter a field in a PivotTable list
Remove filters to display all data in a PivotTable list
Allow multiple selection in the filter area
Refreshing a PivotTable List
Refresh a PivotTable list with updated source data
Using PivotTable Lists in Other Programs
About PivotTable lists that were published from Microsoft Excel
About exporting a PivotTable list to Excel or other applications
Export or copy a PivotTable list to Excel or other applications
Programming Information
Troubleshooting PivotTable Lists
Troubleshoot PivotTable lists
Get in touch
Submit feedback about this site to:
[email protected]