1.                   

Ctrl+0

Hide the selected columns.

2.                   

Ctrl+9

Hide the selected rows.

3.                   

Ctrl+1

Open the Format Cells dialog box.

4.                   

Ctrl+2 or Ctrl+B

Bold text or remove bold formatting.

5.                   

Ctrl+3 or Ctrl+I

Italicize text or remove italic formatting.

6.                   

Ctrl+4 or Ctrl+U

Underline text or remove underline.

7.                   

Ctrl+5

Apply or remove strikethrough formatting.

8.                   

Ctrl+6

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

9.                   

Ctrl+8

Display or hide the outline symbols.

10.               

Alt+F1

Create an embedded chart of the data in the current range.

11.               

F2

Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference.

12.               

Shift+F2

Insert a note.

Open and edit a cell note.

13.               

Ctrl+Shift+F2

Insert a threaded comment.

Open and reply to a threaded comment.

14.               

Shift+F3

Insert a function.

15.               

F4

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

16.               

F7

Check spelling in the active worksheet or selected range.

17.               

F9

Calculate all worksheets in all open workbooks.

18.               

Shift+F9

Calculate the active worksheet.

19.               

Ctrl+Alt+F9

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

20.               

F11

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

21.               

Ctrl+Shift+F or Ctrl+Shift+P

Format fonts in the Format Cells dialog box.

22.               

Ctrl+End

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

23.               

Ctrl+Shift+End

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

24.               

Ctrl+Home

Move to the beginning of a worksheet.

25.               

Page down

Move one screen down in a worksheet.

26.               

Ctrl+Page down

Move to the next sheet in a workbook.

27.               

Alt+Page down

Move one screen to the right in a worksheet.

28.               

Page up

Move one screen up in a worksheet.

29.               

Alt+Page up

Move one screen to the left in a worksheet.

30.               

Ctrl+Page up

Move to the previous sheet in a workbook.

31.               

Tab key

Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells.

32.               

Alt+Down arrow key

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

33.               

Esc

Exit the floating shape navigation and return to the normal navigation.

Cancel an entry in the cell or formula bar.

34.               

Ctrl+Alt+Equal sign ( = )

Zoom in.

35.               

Ctrl+Alt+Minus sign (-)

Zoom out.

36.               

Ctrl+Shift+Plus sign (+)

Open the Insert dialog box to insert blank cells.

37.               

Ctrl+Minus sign (-)

Open the Delete dialog box to delete selected cells.

38.               

Ctrl+Spacebar

Select an entire column in a worksheet.

39.               

Ctrl+Shift+Spacebar

Select all objects on a worksheet when an object is selected.

40.               

Shift+Page down

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

41.               

Shift+Page up

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

42.               

Shift+End

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

43.               

Shift+Home

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

44.               

Ctrl+Page up

Move to the previous table.

45.               

Ctrl+Left arrow key

Move to the first cell of the selected row.

46.               

Ctrl+Right arrow key

Move to the last cell of the selected row.

47.               

Ctrl+Up arrow key

Move to the first cell of the selected column.

48.               

Ctrl+Down arrow key

Move to the last cell of selected column.

49.               

Ctrl+Esc

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

50.               

Alt+Down arrow key

Open the AutoFilter Menu dialog box.

51.               

Ctrl+Shift+Home

Extend the selection of cells to the beginning of the worksheet.

52.               

Ctrl+Shift+U

Expand or collapse the formula bar.

53.               

Enter

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

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

54.               

Ctrl+End

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

55.               

Ctrl+Shift+End

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

56.               

Alt+Equal sign ( = )

Insert the AutoSum formula