F1

Display the Help window.

Ctrl+F1

Show/hide the ribbon.

Alt+F1

Insert a chart as an object.

Shift+Alt+F1

Insert a new worksheet.

Ctrl+Alt+F1

Insert a Microsoft Excel 4 macro worksheet.

F2

Toggle Selection, Edit, and Enter/Point modes.

Shift+F2

Insert/edit a comment.

Alt+F2

Display the Save As dialog box.

Shift+Alt+F2

Save

Ctrl+Alt+F2

Display the Open dialog box.

Shift+Ctrl+Alt+F2

Display the Print dialog box.

F3

Display the Paste Name dialog box.

Shift+F3

Display the Insert Function dialog box.

Ctrl+F3

Display the Name Manager dialog box.

Shift+Ctrl+F3

Display the Create Names From Selection dialog box.

Ctrl+Alt+F3

Display the New Name dialog box.

F4

Redo

Shift+F4

Find the next instance of the most recent search.

Ctrl+F4

Close the workbook.

Alt+F4

Close the application.

Shift+Ctrl+F4

Find the previous instance of the most recent search.

Shift+Alt+F4

Close the application.

Ctrl+Alt+F4

Close the application.

Shift+Ctrl+Alt+F4

Close the application.

F5

Display the Go To dialog box.

Shift+F5

Display the Find And Replace dialog box.

Ctrl+F5

Restore the window.

Shift+F6

Display shortcut key labels. (Or, you can press F6 twice.)

Ctrl+F6

Move to the next window.

Shift+Ctrl+F6

Move to the previous window.

F7

Check spelling.

Ctrl+F7

Move the window.

F8

Extend Selection mode.

Shift+F8

Add to Selection mode.

Alt+F8

Display the Macro dialog box.

F9

Calculate all, or when a portion of a formula is selected, calculate the selected portion.

Shift+F9

Calculate the active worksheet.

Ctrl+F9

Minimize the active window.

Ctrl+Alt+F9

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

Ctrl+Shift+Alt+F9

Recheck dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated.

F10

Display shortcut key labels.

Shift+F10

Activate shortcut (context) menus.

Ctrl+F10

Toggle the maximized/restored window.

F11

Insert a chart on a new worksheet.

Shift+F11

Create a new worksheet.

Ctrl+F11

Create a new macro worksheet.

Alt+F11

Show the Visual Basic Editor.

F12

Display the Save As dialog box.

Shift+F12

Save

Ctrl+F12

Display the Open dialog box.

Shift+Ctrl+F12

Display the Print window.

Backspace

Edit and clear.

Shift+Backspace

Collapse the selection to the active cell.

Ctrl+Backspace

Show the active cell.

Alt+Backspace

Undo

Delete

Clear

Shift+Delete

Cut

Ctrl+Delete

Clear

End

Toggle End mode.

Shift+End

Toggle End mode (and extend when you press Shift+an arrow key).

Ctrl+End

Select the last cell in the worksheet.

Shift+Ctrl+End

Extend the selection to the last cell in the worksheet.

Esc

Cancel (edit, copy, cut, dialog boxes, and so on).

Shift+Esc

Cancel (edit, copy, cut, dialog boxes, and so on).

Ctrl+Esc

Display the Windows Start menu.

Shift+Ctrl+Esc

Display the Windows Task Manager.

Enter

Enter the value, and move down.

Shift+Enter

Enter the value, and move up.

Ctrl+Enter

Fill the value in edited cell into all cells, and do not move.

Alt+Enter

Redo

Shift+Ctrl+Enter

Fill the value in edited cell into all cells, and do not move.

Home

Select the first cell in the row.

Shift+Home

Extend the selection to the first cell in the row.

Ctrl+Home

Select the first cell in the window (or pane).

Shift+Ctrl+Home

Extend the selection to the first cell in the window or pane.

Insert

Toggle Overwrite mode in Edit mode.

Shift+Insert

Paste

Ctrl+Insert

Copy

Left Arrow

Move left one cell.

Down Arrow

Move down one cell.

Shift+Down Arrow

Extend the selection down one cell.

Ctrl+Down Arrow

Select the last cell in the region down.

Alt+Down Arrow

Open the list (AutoComplete, Filter, Pick From List, or Validation).

Shift+Ctrl+Down Arrow

Extend the selection down to the last cell in the current region or the first cell in the next region.

Shift+Left Arrow

Extend the selection left one cell.

Ctrl+Left Arrow

Select the leftmost cell in the current region or the rightmost cell in the next region.

Shift+Ctrl+Left Arrow

Extend the selection left to the last cell in the current region or the first cell in the next region.

Shift+Alt+Left Arrow

Ungroup

Ctrl+Alt+Left Arrow

Move the active cell to the upper-left cell of the selection.

Right Arrow

Move right one cell.

Shift+Right Arrow

Extend the selection right one cell.

Ctrl+Right Arrow

Select the last cell to the right in the current region or the first cell in the next region.

Shift+Ctrl+Right Arrow

Extend the selection to the right, to the last cell in the current region, or the first cell in the next region.

Shift+Alt+Right Arrow

Group

Ctrl+Alt+Right Arrow

Move the active cell to the next nonadjacent region within the selection.

Up Arrow

Move up one cell.

Shift+Up Arrow

Extend the selection up one cell.

Ctrl+Up Arrow

Select the cell at the top of the region.

Shift+Ctrl+Up Arrow

Extend the selection up to the end of the region.

Page Down

Scroll down one page.

Shift+Page Down

Extend the selection down one page.

Ctrl+Page Down

Move to the next worksheet.

Alt+Page Down

Scroll one page right.

Shift+Ctrl+Page Down

Extend the selection one worksheet down.

Shift+Alt+Page Down

Extend the selection one page right.

Page Up

Scroll up one page.

Shift+Page Up

Extend the selection one page up.

Ctrl+Page Up

Move to the previous worksheet.

Alt+Page Up

Scroll one page left.

Shift+Ctrl+Page Up

Extend the selection one worksheet up.

Shift+Alt+Page Up

Extend the selection one page left.

Return

Enter the value, and move down.

Shift+Return

Enter the value, and move up.

Ctrl+Return

Fill the value in the edited cell into all selected cells and do not move.

Alt+Return

Redo

Shift+Ctrl+Return

Fill the value in the edited cell into all selected cells and do not move.

Shift+Spacebar

Select row.

Ctrl+Spacebar

Select column.

Shift+Ctrl+Spacebar

Select all.

Tab

Move to the next cell to the right.

Shift+Tab

Move to the next cell to the left.

Ctrl+Tab

Move to the next window.

Alt+Tab

Move to the next application.

Shift+Ctrl+Tab

Move to the previous window.

Shift+Alt+Tab

Indent

Ctrl+Alt+Tab

Outdent

Ctrl+0

Hide the selected column.

Ctrl+1

Display the Format Cells dialog box.

Shift+Ctrl+1

Apply the two-decimal-place Number format with the thousands separator.

Ctrl+2

Toggle bold formatting.

Shift+Ctrl+2

Apply the Time (AM/PM) format.

Ctrl+3

Toggle italic formatting.

Shift+Ctrl+3

Apply the Date format.

Ctrl+4

Toggle underline formatting.

Shift+Ctrl+4

Apply the Currency format.

Ctrl+5

Toggle strikethrough formatting.

Shift+Ctrl+5

Apply the Percentage format.

Ctrl+6

Toggle the display of objects (between Show, Hide, and Show Placeholders).

Shift+Ctrl+6

Apply the two-place exponential Scientific format.

Shift+Ctrl+7

Apply the Outline border format.

Ctrl+8

Toggle the outline symbol display.

Shift+Ctrl+8

Select the current region.

Ctrl+9

Hide the selected row.

Shift+Ctrl+9

Show the row.

Ctrl+’ (apostrophe)

Copy the underlying value (entered value or exact formula) of the above cell, and edit.

Alt+’ (apostrophe)

Display the Style dialog box.

Shift+Ctrl+’ (apostrophe)

Copy the displayed value in the above cell and edit.

Ctrl+– (hyphen)

Display the Delete dialog box.

Shift+Ctrl+– (hyphen)

Remove all the borders.

Shift+Ctrl+, (comma)

Fill down.

Ctrl+. (period)

Rotate the active cell through the corners of the selection.

Shift+Ctrl+. (period)

Fill right.

Ctrl+/ (slash)

Select array.

Ctrl+; (semicolon)

Insert the current date.

Shift+Ctrl+; (semicolon)

Insert the current time.

Ctrl+[ (open bracket)

Select the direct precedent cells.

Shift+Ctrl+[ (open bracket)

Select all the precedent cells.

Ctrl+] (close bracket)

Select the directly dependent cells.

Shift+Ctrl+] (close bracket)

Select all the dependent cells.

Ctrl+Shift+{ (open brace)

Select all the cells directly or indirectly referenced by formulas in the selection.

Ctrl+Shift+} (close brace)

Select cells that contain formulas that directly or indirectly reference the active cell.

Ctrl+` (single left quotation mark)

Display formulas.

Shift+Ctrl+` (single left quotation mark)

Apply the General format.

Ctrl+= (equal sign)

Calculate now.

Alt+= (equal sign)

AutoSum

Shift+Ctrl+= (equal sign)

Display the Insert dialog box.

Ctrl+Add (keypad)

Display the Insert dialog box.

Ctrl+Decimal (keypad)

Rotate the active cell through the corners of the selection.

Ctrl+Divide (keypad)

Select the array.

Ctrl+Multiply (keypad)

Select the current region.

Ctrl+Subtract (keypad)

Display the Delete dialog box.

Ctrl+A

Select the current region or select all.

Shift+Ctrl+A

Insert arguments in the formula.

Ctrl+B

Apply bold formatting.

Ctrl+C

Copy

Ctrl+D

Fill down.

Ctrl+F

Display the Find And Replace dialog box, Find tab.

Shift+Ctrl+F

Display the Format Cells dialog box, Font tab.

Ctrl+G

Display the Go To dialog box.

Ctrl+H

Display the Find And Replace dialog box, Replace tab.

Ctrl+I

Apply italic formatting.

Ctrl+K

Display the Insert Hyperlink dialog box.

Ctrl+L

Display the Create Table dialog box.

Shift+Ctrl+L

Toggle AutoFilter.

Ctrl+N

Create a new workbook.

Ctrl+O

Display the Open dialog box.

Shift+Ctrl+O

Select the first cell containing a comment.

Ctrl+P

Display the Print window.

Shift+Ctrl+P

Display the Format Cells dialog box, Font tab.

Ctrl+R

Fill right.

Ctrl+S

Save the workbook.

Ctrl+T

Display the Create Table dialog box.

Shift+Ctrl+T

Toggle the total row (when the table is selected).

Ctrl+U

Toggle the underline format.

Ctrl+V

Paste

Ctrl+Alt+V

Display the Paste Special dialog box.

Ctrl+W

Close the window.

Ctrl+X

Cut

Ctrl+Y

Redo

Ctrl+Z

Undo