Share via

PowerPivot Window: Keyboard Shortcuts

  • Article

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

This topic contains a list of keyboard shortcuts that can be used in the PowerPivot window. For an overview of the user interface and instructions on how to open the PowerPivot window, see Take a Tour of the PowerPivot UI.

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 PowerPivot window. For more information, see Recalculate Formulas.

See Also

Concepts

Take a Tour of the PowerPivot UI