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.
Up arrow	Moves the focus up one item in the current dialog area.
Down arrow	Moves the focus down one item in the current dialog area.
Left arrow	Moves the focus one item to the left in the current dialog area.
Right arrow	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  +  Up Arrow	Moves the current field up one place.
Ctrl  +  Down Arrow	Moves the current field down one place.
Ctrl  +  Left Arrow	Moves the current field one place to the left.
Ctrl  +  Right Arrow	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.