Level 13
Level 14

Pivot Tables


15 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
arrow keys
Navigate inside Pivot tables.
home/end
Select the first / last visible item in the list.
alt+c
Move the selected field into the Column area.
alt+d
Move the selected field into the Data area.
alt+l
Display the PivotTable Field dialog box.
alt+p
Move the selected field into the Page area.
alt+r
Move the selected field into the Row area.
ctrl+shift+* (asterisk)
Select the entire PivotTable report.
arrow keys to select cell that contains field, then alt+arrow down
Display the list for the current field in a PivotTable report.
arrow keys to select page field, then alt+arrow down
Display the list for the current page field in a PivotChart report.
enter
Display the selected item.
space
Select or clear a check box in the list.
ctrl+tab
select the PivotTable toolbar.
enter then arrow down/up
On a field button: select the area you want to move the selected field to.
alt+shift+arrow right/left
Group/Ungroup selected PivotTable items.