Keyboard Shortcut Keys for MS Excel

Keyboard Shortcut Keys for MS Excel

MS Excel is a cell contained spreadsheet software. There are many Keyboard Shortcut Keys to execute the command of Excel. Below are listed all the Keyboard Shortcut Keys for MS Excel.

Shortcut key	Description
Ctrl + ↑	Move to first cell of column
Ctrl + ↓	Move to last cell of column
Ctrl + →	Move to last cell of Row
Ctrl + ←	Move to first cell of Row
Ctrl + Home key	Move to first cell of the Sheet
Alt + =	Insert auto sum
F5	Display the “Go To”dialogue box
Esc	Cancel a cell enrty
Ctrl + ;	Enter date
Ctrl + Shift + :	Enter time
Ctrl + 1	Display the”Format cell”dialogue Box
Alt + Page Down	Move one Screen to the Right
Alt + Page Up	Move one Screen to the Left
Ctrl + Shift + &	Apply the outline Border
Ctrl + Shift + -	Remove the outline Border
Ctrl + 5	Apply or Remove strick through Formating
Ctrl + 9	Hide Row
Ctrl + Shift + (	Unhide Row
Ctlr + 0	Hide column
Ctrl + Shift + )	Unhide column
Ctrl + Space Bar	Select the entire column
Shift + Space Bar	Select the entire Row
Shift + F11	Insert a new Worksheet
Alt + Shift + F1	Insert a new Worksheet
Ctrl + Plus	Insert a column or Row in a worksheet
Ctrl + -	Remove a column or Row in a worksheet
Ctrl + Page Down	Move to a next sheet in a workbook
Ctrl + Page Up	Move to previous sheet in a workbook
Page Down	Move Down one screen
Page Up	Move Up one screen
Ctrl + D	Fill Down
Ctrl + R	Fill Right
F2	Edit a active cell
Ctrl + Tab	Move another open workbook

You can read more articles related to this article
Common Computer Shortcut Keys
Keyboard Shortcut Keys of Most Commonly Used Commands
Keyboard Shortcut Keys for MS Word
Keyboard Shortcut Keys for Selection of Text

Keyboard Shortcut Keys to Move the Insertion Point

Keyboard Shortcut keys for Inpage