Microsoft Excel Keyboard Shortcuts

 

 - Microsoft Excel Shortcuts -

 

Ctrl + A	To select all the contents in a workbook.
Ctrl + B	To turn highlighted cells bold.
Ctrl + C	To copy cells that are highlighted.
Ctrl + D	To fill the selected cell with the content of the cell right above.
Ctrl + F	To search for anything in a workbook.
Ctrl + G	To jump to a certain area with a single command.
Ctrl + H	To find and replace cell contents.
Ctrl + I	To italicise cell contents.
Ctrl + K	To insert a hyperlink in a cell.
Ctrl + L	To open the create table dialog box.
Ctrl + N	To create a new workbook.
Ctrl + O	To open a saved workbook.
Ctrl + S	To save a workbook.
Ctrl + P	To print a workbook.
Ctrl + R	To fill the selected cell with the content of the cell on the left.
Ctrl + U	To underline highlighted cells.
Ctrl + V	To paste anything that was copied.
Ctrl + W	To close your current workbook.
Ctrl + Z	To undo the last action.
Ctrl + F2	To open the print preview window.
Ctrl + F1	To expand or collapse the ribbon.
Tab	Move to the next cell.
F1	To open Microsoft Excel help.
Ctrl + F4	To close Microsoft Excel.
Ctrl+:	Insert Current Time
Ctrl+;	Insert Current Date
F2	Edit
F3	Paste Name
F4	Repeat last action
F5	Goto
F6	Next Pane
F7	Spell check
F8	Extend mode
F9	Recalculate all workbooks
F10	Activate Menubar
F11	New Chart
F12	Save As
Ctrl++	Insert
Ctrl+-	Delete
Ctrl+1	Format cells dialog box
Ctrl+2	Bold
Ctrl+3	Italic
Ctrl+4	Underline
Ctrl+5	Strikethrough
Ctrl+6	Show/Hide objects
Ctrl+7	Show/Hide Standard toolbar
Ctrl+8	Toggle Outline symbols
Ctrl+9	Hide rows
Ctrl+0	Hide columns
Ctrl+Shift+(	Unhide rows
Ctrl+Shift+)	Unhide columns
Alt or F10	Activate the menu