Loading...

Welcome to StudyVen

F9 : Recalculate all formulas in the Power Pivot window. For more information, see Recalculate Formulas in Power Pivot.
Open the context menu. : Ctrl+Shift+F10
Alt+Down arrow : Open the AutoFilter Menu dialog.
F5 : Open the Go To dialog.
Ctrl+Down arrow : Move to the last cell of selected column.
Ctrl+Esc : Close a dialog or cancel a process, such as a paste operation.
Ctrl+Right arrow : Move to the last cell of selected row.
Ctrl+Up arrow : Move to the first cell of selected column.
Ctrl+End : Move to the last cell in the lower right corner of selected table (the last row of the Add Column).
Ctrl+Left arrow : Move to the first cell of selected row.
Ctrl+Page Down : Move to the next table.
Ctrl+Home : Move to the first cell in the upper left corner of selected table.
Ctrl+Page Up : Move to the previous table.
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.
Shift+Page Up : Select all cells from the current location to the last cell of the column.
Shift+Page Down : Select all cells from the current location to the first cell of the column.
Ctrl+Spacebar : Select the current column.
Shift+Spacebar : Select the current row.
Ctrl+Y : Redo the last action.
Ctrl+Z : Undo the last action.
Ctrl+R : Rename the table.
Ctrl+S : Save the file.
Ctrl+D : Delete the table.
Ctrl+M : Move the table.
Ctrl+A : Select the entire table.
Ctrl+C : Copy selected data.
Refresh all data in the workbook : Ctrl+Alt+F5
Right-click : Open the context menu for the selected cell, column, or row.
Stop a refresh operation : Esc