Power Pivot keyboard shortcuts and accessibility

This topic contains a list of keyboard shortcuts that can be used in Power Pivot.

Key combination

Description

Right-click

Open the context menu for the selected cell, column, or row.

CTRL+A

Select the entire table.

CTRL+C

Copy selected data.

CTRL+D

Delete the table.

CTRL+M

Move the table.

CTRL+R

Rename the table.

CTRL+S

Save the file.

CTRL+Y

Redo the last action.

CTRL+Z

Undo the last action.

CRTL+Space

Select the current column.

SHIFT+Space

Select the current row.

SHIFT+PgUp

Select all cells from the current location to the last cell of the column.

SHIFT+PgDn

Select all cells from the current location to the first cell of the column.

SHIFT+End

Select all cells from the current location to the last cell of the row.

SHIFT+Home

Select all cells from the current location to the first cell of the row.

CTRL+PgUp

Move to the previous table.

CTRL +PgDn

Move to the next table.

CRTL+Home

Move to the first cell in the upper left corner of selected table.

CRTL+END

Move to the last cell in the lower right corner of selected table (the last row of the Add Column).

CTRL+Left

Move to the first cell of selected row.

CTRL+Right

Move to the last cell of selected row.

CTRL+Up

Move to the first cell of selected column.

CTRL+Down

Move to the last cell of selected column.

CTRL+Esc

Close a dialog box or cancel a process, such as a paste operation.

ALT+Down

Open the AutoFilter Menu Dialog Box.

F5

Open the Go To Dialog Box.

F9

Recalculate all formulas in the Power Pivot window. For more information, see Recalculate Formulas in Power Pivot.

Top of Page

Applies To: Excel 2013, Office 365 End User



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language