How can we help you?
   Open the pivot table settings pane
  • Interface overview
  •    Screen elements
  •    Toolbar
  •    Quick actions box
  • General information
  • Files
  •    New file
  •    Save as template
  •    New from template
  •    Open a file
  •    Recent files
  •    Open with
  •    Send a file
  •    Print document without entering the application
  •    Preview and print
  •    Save a file
  •    Autorecovery of documents
  •    Close a file
  • Sheets
  •    Insert a sheet
  •    Rename a sheet
  •    Hide or unhide sheets
  •    Duplicate a sheet
  •    Change sheets order
  •    Zoom a sheet
  •    Hide or display zero values
  •    Delete a sheet
  • Cells, columns, and rows
  •    Expand the workspace
  •    Select cell ranges
  •    Resize cells
  •    Merge or unmerge cells
  •    Insert columns or rows
  •    Select colums or rows
  •    Hide or unhide a column or row
  •    Resize a column or row
  •    Freeze columns, rows, or area
  •    Group columns or rows
  •    Delete columns or rows
  • Data
  •    Enter data
  •    Sort and filter
  •    Data validation
  •    Remove duplicates
  •    Links
  •    Notes
  •    Special characters
  •    Current date or time
  •    Check spelling
  •    Find and replace
  •    Delete data
  • Number formats
  •    Identify cell format
  •    Open number format settings window
  •    General
  •    Number
  •    Currency
  •    Accounting
  •    Date, Time, and Date and Time
  •    Percentage
  •    Fraction
  •    Scientific
  •    Text
  • Formulas and functions
  •    Formulas and functions basics
  •    Order of operations in a formula
  •    Reference cells and cell ranges
  •    Recalculation of formulas
  •    Automatic calculation
  •    Enter functions
  •    Replace a formula with its result
  •    Copy and insert formulas
  •    Names in formulas and functions
  •    Reference to data in another document
  •    Structured references
  • Calculation operators
  •    Arithmetic operators
  •    Comparison operators
  •    Text concatenation operator 
  •    Reference operators
  • Tables
  •    Create a table
  •    Open the table settings pane
  •    Table customization
  •    Automatic table expansion
  •    Add a calculated column
  •    Select the type of calculation in the total row
  •    Convert a table to a regular range
  •    Delete a table
  • Pivot tables
  •    Create a pivot table
  •    Open the pivot table settings pane
  •    Customize a pivot table
  •    Customize the pivot table parameters
  •    Collapse or expand the elements of pivot table
  •    View cell details
  •    Refresh a pivot table
  •    Delete a pivot table
  • Charts
  •    Create a chart
  •    Chart settings
  •    Move a chart
  •    Copy, cut or insert a chart
  •    Change chart type
  •    Resize a chart
  •    Change data in chart
  •    Change chart data source
  •    Delete a chart
  • Images
  •    Insert an image
  •    Resize an image
  •    Move an image
  •    Save an image
  •    Delete an image
  • Shapes
  •    Insert a shape
  •    Fill a shape
  •    Outline
  •    Line style
  •    Resize a shape
  •    Fit shape size to text
  •    Change line length and angle
  •    Select arrow type
  •    Move a shape
  •    Delete a shape
  • Format
  •    Font
  •    Font size
  •    Font formatting
  •    Font сolor
  •    Highlight color
  •    Alignment
  •    Rotate text
  •    Wrap text
  •    Character spacing
  •    Cell background color
  •    Cell borders
  •    Copy and apply formatting
  • Edit content
  •    Undo and redo
  •    Clipboard
  • Automation tools
  •    Macros
  • Document protection
  •    Protect content from changes
  • Appendices
  •    Appendix A. List of functions
  •    Appendix B. List of supported currencies

You can configure the pivot table by using the pane that contains the following tabs:

Constructor: Use this tab to select the structure (layout) of the pivot table.

Options: This tab contains the pivot table parameters.

The pivot table settings pane opens automatically when you select any cell in the pivot table and collapses automatically when you select any cell outside the pivot table.

The pivot table settings pane is unavailable if the sheet with the pivot table is protected from changes and the Work with pivot tables option is disabled in the Allowed actions list.

You can also open and collapse the pivot table settings pane manually.

If you close the pane manually, the pane will not open or close automatically until the next time you open the application.

To collapse the pane manually, do one of the following:

At the top of the pane, click fp_header_back_icon.

On the Sidebar, click side_panel_pivot_table Pivot Table.

To open the pane manually, do the following:

1.Select the entire range or one/several cells from the range of the pivot table.

2.Open the pane in one of the following ways:

In the Data menu, click Pivot Table Settings.

On the Toolbar, in the Pivot Table section, click t_pivot_table_settings Pivot Table Settings.

On the Sidebar, click side_panel_pivot_table Pivot Table.

Right-click to open the context menu and run the Pivot Table Settings command.

Was this helpful?
Yes
No
Previous
Create a pivot table
Next
Customize a pivot table