1.      

Ctrl + A

or Ctrl+Shift+Spacebar

Select the entire worksheet.

2.      

Ctrl + B

Apply or remove bold formatting.

3.      

Ctrl + C

Copy selection.

4.      

Ctrl + D

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

5.      

Ctrl + E

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

6.      

Ctrl + F

Find an element

7.      

Ctrl + G or

F5

Open the Go To dialog box.

8.      

Ctrl + H

Replace an element

9.      

Ctrl+I or Ctrl+3

Italicize text or remove italic formatting.

10.   

Ctrl + J

–

11.   

Ctrl + K

Open the Insert hyperlink dialog box.

12.   

Ctrl + L

Ctrl + T

Display the Create Table dialog box.

13.   

Ctrl + M

–

14.   

Ctrl + N

Create New Excel Document

15.   

Ctrl + O

Open a workbook.

16.   

Ctrl + P

Print

17.   

Ctrl + Q

Display the Quick Analysis options for selected cells that contain data.

18.   

Ctrl + R

Copy row

19.   

Ctrl + S

Save a workbook.

20.   

Ctrl + T

Display the Create Table dialog box.

21.   

Ctrl + U

Underline selected cell

22.   

Ctrl + V

Paste the copied elements

23.   

Ctrl + W

Close the current workbook

24.   

Ctrl + X

Cut a selection.

25.   

Ctrl + Y

Repeat the last command or action, if possible.

26.   

Ctrl + Z

Undo recent action.