157 Excel Keyboard Shortcut

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