|
Shortcut Keys |
Description |
|
F2 |
Edit the selected cell. |
|
F5 |
Go to a specific cell. For example, C6. |
|
F7 |
Spell check selected text and/or document. |
|
F11 |
Create chart. |
|
Ctrl + Shift + ; |
Enter the current time. |
|
Ctrl + ; |
Enter the current date. |
|
Alt + Shift + F1 |
Insert New Worksheet. |
|
Shift + F3 |
Open the Excel formula window. |
|
Shift + F5 |
Bring up search box. |
Ctrl + A
|
Select all contents of the worksheet. |
|
Ctrl + B |
Bold highlighted selection. |
|
Ctrl + I |
Italic highlighted selection. |
|
Ctrl + K |
Insert link. |
|
Ctrl + U |
Underline highlighted selection. |
|
Ctrl + 5 |
Strikethrough highlighted selection. |
|
Ctrl + P |
Bring up the print dialog box to begin printing. |
|
Ctrl + Z |
Undo last action. |
|
Ctrl + F9 |
Minimize current window. |
|
Ctrl + F10 |
Maximize currently selected window. |
|
Ctrl + F6 |
Switch between open workbooks / windows. |
|
Ctrl + Page up |
Move between Excel work sheets in the same Excel document. |
|
Ctrl + Page down |
Move between Excel work sheets in the same Excel document. |
|
Ctrl + Tab |
Move between Two or more open Excel files. |
|
Alt + = |
Create a formula to sum all of the above cells |
|
Ctrl + ' |
Insert the value of the above cell into cell currently
selected. |
|
Ctrl + Shift + ! |
Format number in comma format. |
|
Ctrl + Shift + $ |
Format number in currency format. |
|
Ctrl + Shift + # |
Format number in date format. |
|
Ctrl + Shift + % |
Format number in percentage format. |
|
Ctrl + Shift + ^ |
Format number in scientific format. |
|
Ctrl + Shift + @ |
Format number in time format. |
|
Ctrl + Arrow key |
Move to next section of text. |
|
Ctrl + Space |
Select entire column. |
|
Shift + Space |
Select entire row. |
top 
