Keyboard shortcuts for Excel

Select the entire table

Copy selected data

Delete the table

Move the table

Rename the table

Save the file

Redo the last action

Undo the last action

Select the current column

Select the current row

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

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

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

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

Move to the previous table

Move to the next table

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

Move to the last cell in the lower right corner of the selected table

Move to the first cell of selected row

Move to the last cell of selected row

Move to the first cell of selected column

Move to the last cell of selected column

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

Open the AutoFilter Menu dialog

Open the Go To dialog

Recalculate all formulas in the Power Pivot window

Move to the previous cell in a worksheet or the previous option in a dialog

Move one cell up in a worksheet

Move one cell down in a worksheet

Move one cell left in a worksheet

Move one cell right in a worksheet

Move to the last cell in the row or column

Move to the last cell on a worksheet, to the lowest used row of the rightmost used column

Extend the selection of cells to the last used cell on the worksheet (lower-right corner)

Move to the beginning of a worksheet

Move one screen down in a worksheet

Move to the next sheet in a workbook

Move one screen to the right in a workbook

Move one screen up in a worksheet

Move one screen to the left in a worksheet

Move to the previous sheet in a workbook

Move one cell to the right in a worksheet

Open the list of validation choices on a cell that has data validation options applied to it

Cycle through floating shapes (such as text boxes or images)

Exit the floating shape navigation and return to the normal navigation

Select the entire worksheet

Select the current and next sheet in a workbook

Select the current and previous sheet in a workbook

Turn extend mode on and use the arrow keys to extend a selection (toggle)

Add a non-adjacent cell or range to a selection of cells by using the arrow keys

Start a new line in the same cell

Fill the selected cell range with the current entry

Complete a cell entry and select the cell above

Select an entire column in a worksheet

Select an entire row in a worksheet

Select all objects on a worksheet when an object is selected

Extend the selection of cells to the beginning of the worksheet

Select the current region if the worksheet contains data

Select the current region around the active cell

Select the first command on the menu when a menu or submenu is visible

Repeat the last command or action, if possible

Undo the last action

Edit the active cell and put the insertion point at the end of its contents

Expand or collapse the formula bar

Cancel an entry in the cell or Formula Bar

Complete an entry in the formula bar and select the cell below

Move the cursor to the end of the text when in the formula bar

Select all text in the formula bar from the cursor position to the end

Calculate all worksheets in all open workbooks

Calculate the active worksheet

Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation

Display the menu or message for an Error Checking button

Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula

Insert argument names and parentheses when the insertion point is to the right of a function name in a formula

Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column

Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected

Insert a function

Copy the value from the cell above the active cell into the cell or formula bar

Create an embedded chart of the data in the current range

Create a chart of the data in the current range in a separate Chart sheet

Define a name to use in references

Paste a name from the Paste Name dialog

Move to the first field in the next record of a data form

Create, run, edit, or delete a macro

Open the Microsoft Visual Basic for Applications Editor

Open the Format Cells dialog

Format fonts in the Format Cells dialog

Edit the active cell and put the insertion point at the end of its contents

Add or edit a cell comment

Open the Delete dialog to delete selected cells

Enter the current date

Switch between displaying cell values or formulas in the worksheet

Copy a formula from the cell above the active cell into the cell or Formula Bar

Move the selected cells

Copy the selected cells

Paste content at the insertion point, replacing any selection

Open the Paste Special dialog

Italicize text (toggle)

Bold text (toggle)

Underline text (toggle)

Apply or remove strikethrough formatting

Switch between hiding objects, displaying objects, and displaying placeholders for objects

Display or hide the outline symbols

Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below

Open the Insert hyperlink dialog

Check spelling in the active worksheet or selected range

Display the Quick Analysis options for selected cells that contain data

Display the Create Table dialog