Shortcuts

Apache OpenOffice 4.1 Calc Guide

Chapter 8: Using Pivot Tables

< Previous Section

Next Section >

• Introduction
• Examples with Step-by-Step Descriptions
  • Example 1: Sales Volume Overview
    • Practical Problems and Questions
    • Solution
    • Advantages
  • Example 2: Timekeeping
    • Practical Problems and Questions
    • Solution
    • Differences and Advantages
  • Example 3: Frequency Distribution
    • Solution with an Array Formula
    • Solution with a Pivot Table
• Functions in Detail
  • The Database
  • Start
  • Data Sources
    • Calc Spreadsheet
    • Registered Data Source
  • The Pivot Table Dialog
    • Basic Layout
    • More Options
    • More Settings for the Fields – Field Options
    • Data Fields
    • Row and Column Fields
    • Page Fields
  • Working with the Results of the Pivot Table
    • Start the Dialog
    • Change Layout by Using Drag and Drop
    • Grouping Rows or Columns
    • Grouping of Categories with Scalar Values
    • Grouping of Categories with Date or Time Values
    • Grouping without the Automatic Creation of Intervals
    • Sorting the Result
    • Drilling (Showing Details)
    • Filtering
    • Updating or Refreshing Changed Values
    • Cell Formatting
  • Multiple Data Fields
  • Shortcuts
• Function GETPIVOTDATA
  • Difficulty
  • Syntax
    • First Syntax Variation
    • Second Syntax Variation

< Previous Page

Next Page >

Shortcuts

If you use Pivot Tables very often, you might find the frequent use of the menu paths (Data → Pivot Table → Create and Data → Group and Outline → Group) inconvenient.

For grouping, a shortcut is already defined:  F12 . What's more, when creating a Pivot Table, you can define your own keyboard shortcut. If you prefer toolbar icons instead of keyboard shortcuts, you can create a user-defined symbol and add it to either your custom-made toolbar or the Standard toolbar.

For an explanation of how to create keyboard shortcuts or add icons to toolbars, see Chapter 14 (Setting Up and Customizing Calc).