MICROSOFT EXCEL SHORTCUT KEYS

MICROSOFT EXCEL SHORTCUT KEYS

F2 – Edit the selected cell

F5 – Go to a specific cell

F7 – Spell check selected text 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 + 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 + O – Open options

Ctrl + N – Open new document

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 + 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 + Space – Select entire column

Shift + Space – Select entire row

Ctrl + W – Close document