Excel 2013 Keyboard Shortcuts Keyboard Shortcuts by Webucator

CTRL combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2013
excel microsoft office 2013

Ctrl+PgDn	Go to next worksheet tab
Ctrl+PgUp	Go to previous worksheet tab
Ctrl+Shift+&	Add outline border
Ctrl+Shift+&	Add outline border
Ctrl+Shift_	Removes outline border
Ctrl+Shift+~	Apply general number format
Ctrl+Shift+$	Apply currency format
Ctrl+Shift+%	Apply percentage format
Ctrl+Shift+%	Apply percentage format
Ctrl+Shift+^	Apply scientific number format
Ctrl+Shift+#	Apply date format
Ctrl+Shift+@	Apply time format
Ctrl+Shift+!	Apply number format
Ctrl+Shift+*	Select block of neighboring cells
Ctrl+Shift+:	Enter current time
Ctrl+Shift+"	Copy value of above cell
Ctrl+Shift+Plus (+)	Insert
Ctrl+Minus (-)	Delete
Ctrl+;	Enter current date
Ctrl+`	Alternate between displaying cell values and formulas
Ctrl+'	Copy formula of above cell
Ctrl+1	Format cells
Ctrl+2	Bold
Ctrl+3	Italic
Ctrl+4	Underline
Ctrl+5	Strikethrough
Ctrl+6	Hide/Show object
Ctrl+8	Hide/Show outline symbols
Ctrl+9	Hide selected rows
Ctrl+0	Hide selected columns
Ctrl+A	Select entire worksheet
Ctrl+B	Bold
Ctrl+C	Copy
Ctrl+D	Fill down
Ctrl+E	Flash fill
Ctrl+F	Find
Ctrl+G	Display Go To dialog box
Ctrl+H	Find and Replace
Ctrl+I	Italicize
Ctrl+K	Hyperlink
Ctrl+L	Create table
Ctrl+N	Create new workbook
Ctrl+O	Display Open dialog box
Ctrl+P	Print
Ctrl+Q	Quick Analysis
Ctrl+R	Fill right
Ctrl+S	Save
Ctrl+T	Create table
Ctrl+U	Underline
Ctrl+V	Paste
Ctrl+W	Close workbook
Ctrl+X	Cut
Ctrl+Y	Redo
Ctrl+Z	Undo

Alt	Show/Hide key tips
Arrow Keys	Move between cells
Ctrl+Arrow Key	Move to edge of current data region
Shift+Arrow Key	Extend selection
Esc	Cancel entry
Tab	Move to cell to the right
Shift+Tab	Move to cell to the left