Shortcut Keys of Pivot Table and Browser

Pivot table shortcut keys are valid only when you are working with a pivot table.

For example, when you click any part of the browser and then press Ctrl + F, the find box of the browser is displayed. When you click any cell in the pivot table and then press Ctrl + F, the Find and Replace of pivot table is displayed.

Common Shortcut Keys

Pivot table supports the following shortcut keys similar to Excel. The listed key combinations are for Windows. For Mac, replace Ctrl key with Command key and Alt key with Option key.

Operation	Key	Description
Copy	Ctrl + C	Copies a value or values in the selected cell or cell range to the clipboard.
Cut	Ctrl + X	Cuts a value or values in the selected cell or cell range for pasting them to other cells. When you cut a cell or cells and paste them into other cells of the pivot table , the values in the source cells are erased. When you paste them into Excel or another window, the values in the source cells are kept. This behavior is same as Excel.
Paste	Ctrl + V	Pastes the value from the clipboard.
Undo	Ctrl + Z	Undoes the last operation. Undo is effective to unsaved data only. Saved data cannot be undone with this operation.
Redo	Ctrl + Y	Redoes the last operation.
Search	Ctrl + F	Displays the Find and Replace Data dialog with the Find tab selected.
Replace	Ctrl + H	Displays the Find and Replace Data dialog with the Replace tab selected.
Enter current date	Ctrl + ;	Works only on date, time, and datetime fields. (Works only in the Japanese environment for Internet Explorer/Microsoft Edge.)
Enter current time	Ctrl + :	Works only on date, time, and datetime fields. (Works only in the Japanese environment for Internet Explorer/Microsoft Edge.)
Start editing a cell	F2, or Fn + F2 for MacBook
Cell entry	Character keys
Cancel cell entry	Esc
Delete cell content	Del or BackSpace
Delete right side of cursor	Ctrl + Del
Confirm cell entry and move down to next cell	Enter
Open drop-down	Alt + ↓	Works on drop-down and multi-choice fields only.
Enter active cell content in all selected cells	Ctrl + Shift + Enter	When more than one cell is selected, enters the value entered in the active cell, in all the selected cells at one time. This operation is assigned to Ctrl + Enter in Excel.
Save data	Ctrl + S	Save your edits.

Moving Cells

The operation of moving cells in the pivot table is similar to Excel.

Operation	Key	Description
Move up one cell	↑ (Up arrow key)
Move down one cell	↓ (Down arrow key)
Move left one cell	← (Left arrow key)
Move right one cell	→ (Right arrow key)
Move to the rightmost column's cell	End
Move to the leftmost column's cell	Home
Move down to the next cell	Enter
Move to the next cell	Tab	Moves to the next cell (right cell). When there is no cell on the right, moves to the first cell of the next record. When a cell range is selected, moves within the selection. When a dialog is displayed, moves to the next control in the dialog.
Move to the previous cell	Shift + Tab	Moves to the previous cell (left cell). When there is no cell on the left, moves to the last cell of the previous record. When a cell range is selected, moves within the selection. When a dialog is displayed, moves to the previous control in the dialog.
Move to the first row, last row, leftmost column, or rightmost column	Ctrl + arrow key
Scroll down one screen	PageDown, or Fn + ↓(down arrow key) for MacBook
Scroll up one screen	PageUp, or Fn + ↑(up arrow key) for MacBook

Selecting Cells

Cell select operations in the pivot table are similar to Excel.

Operation	Key
Select the range to the clicked cell	Shift + click another cell
Expand the selection up, down, left, or right by one cell	Shift + arrow key
Complete cell entry and select above cell	Shift + Enter
Select all cells	Ctrl + A
Extend the selection to the leftmost column	Shift + Home
Extend the selection to the rightmost column	Shift + End