Microsoft Excel Shortcut Keys

F2 Edit the selected cell.
F5 Go to a specific cell.

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 worksheet.

Ctrl + B Bold highlighted selection.
Ctrl + N Open new document.

Ctrl + I Italicize highlighted selection.
Ctrl + C Copy selected text.

Ctrl + V Paste.
Ctrl + D Fill.

Ctrl + K Insert Link.
Ctrl + F Open find and replace options.
Ctrl + G Open go-to options.

Ctrl + H Open find and replace options.
Ctrl + U Underline highlighted selection .

Ctrl + Y Underline selected text.
Ctrl + 5 Strike-through highlighted selection.

Ctrl + O Open options.
Ctrl + P Open print dialog box.

Ctrl + S Save.
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 & Page Down Move between Excel worksheets in the same document.

Ctrl + Tab: Move between two or more open Excel files.
Alt + = Create formula to sum all of above cells.
Ctrl + ‘ Insert value of above cell into current cell.

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 + → Move to next section of text.
Ctrl + Space Select entire column.

Shift + Space Select entire row .
Ctrl + W Close document.