Excel key shortcuts

Key Description

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

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 + U – Underline highlighted selection

Ctrl + P – Bring up the print dialog box to begin printing

Ctrl + Z – Undo last action

Ctrl + F9 – Minimise current workbook

Ctrl + F10 – Maximise currently selected workbook

Ctrl + F6 – Switch between open workbooks/window

Ctrl + page up – Move between Excel worksheet in the same Excel document.

Ctrl + Page Down – Move between Excel worksheets 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 +  –  Arrow key Move to next section to text

Ctrl + Space – Select entire column

Shift +Space – Select entire row