EXCEL SHORTCUT KEYS

Shortcut Keys


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.