|
Key / Key combination |
Description |
|
F4 |
Repeats last action. |
|
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. |
|
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. |
Note
Keys should be pressed in combination not in sequence.
Some more shortcuts for Scrolling across sheets.
Excel Keyboard shortcut for scrolling across in worksheet
