Microsoft Office Excel Keyboard Shortcuts

Following are some shortcut keys of MicroSost Office Excel

Category	Hold	Press	Keyword	Result
Format Data	Ctrl	0	column	Hide columns
Format Data	Ctrl	1	format	Display the Format Cells dialog box
Format Data	Ctrl + Shift	2	time	Apply Time format
Format Data	Ctrl	5	strikethrough	Apply or remove strikethrough formatting
Select Cells	Ctrl	6	object	Alternate between hiding objects, displaying objects, and displaying placeholders for objects
Select Cells	Ctrl	7	toolbar	Show or hide the Standard toolbar
Outline Data	Ctrl	8	outline	Display or hide outline symbols
Format Data	Ctrl	9	row	Hide rows
Enter Data	Ctrl	'	copy	Copy formula from cell above
Format Data	Alt	'	style	Style dialog box
Format Data	Ctrl + Shift	'	number	Apply number format
Edit Data	Ctrl	-	delete	Delete selection
Format Data	Ctrl + Shift	-	border	Remove outline borders
Format Data	Ctrl + Shift	!	number	Apply Number format with 2 decimal places, thousands separator
Enter Data	Ctrl + Shift	"	copy	Copy value from cell above
Format Data	Ctrl + Shift	#	date	Apply the Date format with the day, month, and year
Format Data	Ctrl + Shift	$	currency	Apply Currency format
Format Data	Ctrl + Shift	%	percent	Apply Percentage format with no decimal places
Format Data	Ctrl + Shift	&	border	Apply the outline border
Format Data	Ctrl + Shift	(	row	Unhide rows
Format Data	Ctrl + Shift	)	column	Unhide columns
Select Cells	Ctrl + Shift	*	region	Select the current region
Move within Selection	Ctrl	.	move	Move clockwise to the next corner of the selection
Select Cells	Ctrl	/	array	Select current array
Enter Data	Ctrl + Shift	;	time	Enter the time
Enter Data	Ctrl	;	date	Enter the date
Select Cells	Alt	;	cells	Select visible cells in current selection
Select Cells	Ctrl	[	dependent	Select direct dependents
Select Cells	Ctrl + Shift	[	dependent	Select all dependents
Select Cells	Ctrl	\	difference	Select differences
Select Cells	Ctrl + Shift	\	unequal	Select unequal cells
Select Cells	Ctrl	]	precedent	Select direct precedents
Select Cells	Ctrl + Shift	]	precedent	Select all precedents
Format Data	Ctrl + Shift	^	number	Apply Exponential number format
Enter Data	Ctrl	`	formula	Toggle formula view
Edit Data	Ctrl + Shift	=	insert	Insert blank cells
Enter Data	Alt	=	AutoSum	Insert the AutoSum formula
Enter Data	Ctrl	A	formula	Display Formula Palette after typing function name in formula
Enter Data	Ctrl + Shift	A	formula	Insert the argument names and parentheses for a function after you type a function name in a formula
Select Cells	Ctrl	A	All	Select the entire worksheet
Enter Data		Arrow key	move	Move one character up, down, left, or right
Move and Scroll	Ctrl	Arrow key	move	Move to edge of current region
Move and Scroll		Arrow key	move	Move one cell up, down, left, or right
Select Cells	Ctrl + Shift	Arrow Key	select	Extend the selection to the last nonblank cell in the same column or row as the active cell
Select Cells	Shift	Arrow Key	select	Extend the selection by one cell
Format Data	Ctrl	B	bold	Apply or remove bold formatting
Enter Data		Backspace	delete	Delete character to left of insertion point, or delete selection
Move and Scroll	Ctrl	Backspace	scroll	Scroll to display the active cell
Select Cells	Shift	Backspace	select	Select only the active cell when multiple cells are selected
Edit Data	Ctrl	C	copy	Copy the selection
Enter Data	Ctrl	D	fill	Fill down
Enter Data	Ctrl	Delete	delete	Delete text to the end of the line
Enter Data		Delete	delete	Delete character to right of insertion point, or delete selection
Enter Data	Alt	Down Arrow	AutoComplete	Display the AutoComplete list
Move and Scroll	Ctrl	End	move	Move to the last cell on the worksheet
Select Cells	Ctrl + Shift	End	select	Extend the selection to the last used cell on the worksheet (lower-right corner)
Enter Data	Alt	Enter	line break	Start a new line in the same cell
Enter Data	Ctrl	Enter	fill	Fill the selected cell range with current entry
Enter Data	Ctrl + Shift	Enter	array	Enter formula as array formula
Enter Data	Shift	Enter	complete	Complete cell entry and move up in selection
Enter Data		Enter	complete	Complete cell entry and move down in selection
Enter Data		Esc	cancel	Cancel a cell entry
Menus		Esc	close	Close visible menu or submenu
Windows	Ctrl	Esc	Start	Show the Windows Start menu
Help		F1	Help	Open the Help Task pane
Menus	Shift	F10	shortcut	Show a shortcut menu
Menus		F10	menu	Make the menu bar active
Windows	Ctrl	F10	maximize	Maximize or restore the workbook window
Charts		F11	chart	Create a chart that uses the current range
Macros	Alt	F11	VBE	Display the Visual Basic Editor
Macros	Ctrl	F11	macro	Insert a Microsoft Excel 4.0 macro sheet
Worksheets	Shift	F11	worksheet	Insert a new worksheet
Workbook	Ctrl	F12	open	Display the Open dialog box
Workbook		F12	save as	Open the Save As dialog box
Workbook	Shift	F12	save	Save the file
Print	Ctrl + Shift	F12	print	Display the Print dialog box
Charts	Alt	F2	chart	Create a chart that uses the current range
Enter Data	Shift	F2	comment	Edit a cell comment
Enter Data		F2	edit	Edit the active cell and position the insertion point at the end of the line
Worksheets	Alt + Shift	F2	worksheet	Insert a new worksheet
Enter Data	Ctrl	F3	name	Define a name
Enter Data	Ctrl + Shift	F3	name	Create names from row and column labels
Enter Data	Shift	F3	function	Paste a function into a formula
Enter Data		F3	name	Paste defined name into formula
Enter Data		F4	repeat	Repeat the last action
Move and Scroll	Shift	F4	find	Repeat the last Find action (Find Next)
Windows	Ctrl	F4	close	Close the active workbook window
Move and Scroll	Shift	F5	find	Display the Find dialog box
Move and Scroll		F5	go to	Display the Go To dialog box
Windows	Ctrl	F5	restore	Restore the active workbook window size
Dialog Box		F6	dialog box	In a range selection box, switch focus to the worksheet
Move and Scroll	Ctrl	F6	window	Move to the next workbook or window
Move and Scroll	Ctrl+Shift	F6	window	Move to the previous workbook or window
Move and Scroll	Shift	F6	pane	Move to previous pane in workbook that has been split
Move and Scroll		F6	pane	Move to next pane in split workbook
Edit Data		F7	spell	Display the Spelling dialog box
Windows	Ctrl	F7	move	Carry out Move command (workbook icon menu, menu bar), or use arrow keys to move the window
Macros	Alt	F8	macro	Display the Macro dialog box
Select Cells	Shift	F8	select	Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range
Select Cells		F8	select	Turn on extending a selection by using the arrow keys
Windows	Ctrl	F8	size	Carry out Size command (workbook icon menu, menu bar), or use arrow keys to size the window
Enter Data	Ctrl + Alt	F9	calculate	Calculate all sheets in the active workbook
Enter Data	Shift	F9	calculate	Calculate the active worksheet
Enter Data		F9	calculate	Calculate all sheets in all open workbooks
Windows	Ctrl	F9	minimize	Minimize the workbook window to an icon
Move and Scroll	Ctrl	Home	move	Move to the beginning of the worksheet
Move and Scroll		Home	move	Move to the beginning of the row
Select Cells	Ctrl + Shift	Home	select	Extend the selection to the beginning of the worksheet
Select Cells	Shift	Home	select	Extend the selection to the beginning of the row
Format Data	Ctrl	I	italic	Apply or remove italic formatting
Enter Data	Ctrl	K	hyperlink	Insert a hyperlink
Move within Selection	Ctrl + Alt	Left Arrow	move	Move left between nonadjacent selections
Outline Data	Alt + Shift	Left Arrow	group	Ungroup rows or columns
Select Cells	Ctrl + Shift	O	comment	Select all cells with comments
Print	Ctrl	P	print	Display the Print dialog box
Move and Scroll	Alt	Page Down	move	Move one screen to the right
Move and Scroll	Ctrl	Page Down	move	Move to the next sheet in the workbook
Move and Scroll		Page Down	move	Move down one screen
Select Cells	Shift	Page Down	select	Extend the selection down one screen
Worksheets	Ctrl + Shift	Page Down	select	Select current and next sheet in workbook
Move and Scroll	Alt	Page Up	move	Move one screen to the left
Move and Scroll	Ctrl	Page Up	move	Move to the previous sheet in the workbook
Move and Scroll		Page Up	move	Move up one screen
Select Cells	Shift	Page Up	select	Extend the selection up one screen
Worksheets	Ctrl + Shift	Page Up	select	Select current and previous in workbook
Windows	Alt	Print Screen	copy	Copy the image of the active window to the Clipboard
Windows		Print Screen	copy	Copy the image of the screen to the Clipboard
Enter Data	Ctrl	R	fill	Fill to the right
Move within Selection	Ctrl + Alt	Right Arrow	move	Move right between nonadjacent selections
Outline Data	Alt + Shift	Right Arrow	group	Group rows or columns
Menus	Alt	Spacebar	menu	Show control menu
Select Cells	Ctrl	Spacebar	column	Select the entire column
Select Cells	Ctrl + Shift	Spacebar	objects	With an object selected, select all objects on a sheet
Select Cells	Shift	Spacebar	row	Select the entire row
Move and Scroll	Ctrl	Tab	window	Move to the next workbook or window
Move and Scroll	Ctrl+Shift	Tab	window	Move to the previous workbook or window
Move within Selection	Shift	Tab	left	Move left
Move within Selection		Tab	right	Move right
Windows	Alt	Tab	program	Switch to the next program
Windows	Alt + Shift	Tab	program	Switch to the previous program
Format Data	Ctrl	U	underline	Apply or remove an underline
Edit Data	Ctrl	V	paste	Paste the selection
Windows	Ctrl	W	close	Close the active workbook window
Edit Data	Ctrl	X	cut	Cut the selection
Enter Data	Ctrl	Y	repeat	Repeat the last action
Edit Data	Ctrl	Z	undo	Undo the last action