Excel 2013 Keyboard Shortcuts Keyboard Shortcuts by Webucator

Ctrl+PgDn	Go to next worksheet tab
Ctrl+PgUp	Go to previous worksheet tab
Ctrl+S­hif­t+&	Add outline border
Ctrl+S­hif­t+&	Add outline border
Ctrl+S­hift_	Removes outline border
Ctrl+S­hift+~	Apply general number format
Ctrl+S­hift+$	Apply currency format
Ctrl+S­hift+%	Apply percentage format
Ctrl+S­hift+%	Apply percentage format
Ctrl+S­hift+^	Apply scientific number format
Ctrl+S­hift+#	Apply date format
Ctrl+S­hift+@	Apply time format
Ctrl+S­hift+!	Apply number format
Ctrl+S­hift+*	Select block of neighb­oring cells
Ctrl+S­hift+:	Enter current time
Ctrl+S­hif­t+"	Copy value of above cell
Ctrl+S­hif­t+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	Strike­through
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

F1	Help
F2	Edit active cell
F3	Paste Name
F4	Redo
F5	Display Go To dialog box
F6	Toggle control
Shift+F6	Toggle Control (reverse)
F7	Spell check
F8	Extend mode
F9	Calculate all worksheets
Shift+F9	Calculate active worksheet
F10	Show/hide key tips
F11	Create Chart sheet
F12	Save As
Ctrl+F1	Show/Hide Ribbon
Alt+F1	Create embedded chart
Alt+Sh­ift+F1	Insert worksheet
Shift+F2	Add/Edit comment
Ctrl+F2	Print Preview
Shift+F3	Insert function
Ctrl+F4	Close workbook
Alt+F4	Close Excel
Ctrl+F6	Switch workbook
Ctrl+F7	Move window
Ctrl+F8	Resize window
Alt+F8	Display Macro dialog box
Ctrl+F9	Minimize window
Shift+F10	Display shortcut menu
Ctrl+F10	Maximi­ze/­Restore window
Shift+F11	Insert worksheet
Alt+F11	Open VBA Editor

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