Microsoft Excel shortcut keys

Shortcut keys Action

Ctrl+A Apply to select all cells

Ctrl+B Apply/Remove bold formatting

Ctrl+C Apply to copy the selected word

Ctrl+D Apply to fill down the selected cell

Ctrl+F Display the Find what option

Ctrl+G Apply to run Go to dialog box

Ctrl+H Use to display Find and Replace dialog box

Ctrl+I Apply/Remove Italic formatting

Ctrl+K Apply to insert Hyperlink dialog box

Ctrl+L Press keys to insert Create list dialog box

Ctrl+N Press Keys to create new file

Ctrl+O Press Keys to open new file

Ctrl+P Press Keys to display Print dialog box

Ctrl+S Save the active file

Ctrl+U Press Keys to apply/remove underline

Ctrl+V Press Keys to paste the clipboard values

Ctrl+X Press Keys to cut the selected word

Ctrl+Y Press Keys to run previous action

Ctrl+Z Apply to undo the previous command

Uses of Function keys in Excel

Function keys Action

F1 Use to give the help of any windows panel

F2 Press Keys to edit any cell

F3 Use to insert name into formula

F4 Apply to repeat the previous command

F5 Apply to run Go to dialog box

F6 Apply to move between panel in worksheet

F7 Use to check spelling in worksheet

F8 Apply the extend mode on the status line

F9 Use to calculate the worksheets

F10 Use to select the main menu bar

F11 Apply to insert the chart of active worksheet

F12 Use to run Save As dialog box.