Pivot Table Shortcuts

Apache OpenOffice 4.1 Calc Guide

Appendix A — Keyboard Shortcuts

< Previous Section

Next Section >

• Introduction
• Navigation and Selection Shortcuts
• Function and Arrow Key Shortcuts
• Cell Formatting Shortcuts
• Pivot Table Shortcuts

< Previous Page

Next Page >

Pivot Table Shortcuts

These shortcuts apply to the dialog used to define the layout of a Pivot Table.

Table 35: Pivot Table shortcut keys

Shortcut Keys	Effect
Tab ⇆	Changes the focus by moving forward through the areas and buttons of the dialog.
⇧ Shift  +  Tab ⇆	Changes the focus by moving backward through the areas and buttons of the dialog.
↑	Moves the focus up one item in the current dialog area.
↓	Moves the focus down one item in the current dialog area.
←	Moves the focus one item to the left in the current dialog area.
→	Moves the focus one item to the right in the current dialog area.
Home	Selects the first field in the current layout area.
End	Selects the last field in the current layout area.
Alt  +  R	Copies or moves the current field into the “Row” area.
Alt  +  C	Copies or moves the current field into the “Column” area.
Alt  +  D	Copies or moves the current field into the “Data” area.
Ctrl  +  ↑	Moves the current field up one place.
Ctrl  +  ↓	Moves the current field down one place.
Ctrl  +  ←	Moves the current field one place to the left.
Ctrl  +  →	Moves the current field one place to the right.
Ctrl  +  Home	Moves the current field to the first place.
Ctrl  +  End	Move the current field to the last place.
Alt  +  O  (the letter O)	Displays the options for the current field.
Delete	Removes the current field from the area.