Excel Keyboard Sortcuts

Knowing some popular Excel keyboard shortcuts can save you lots of time when creating or working in an Excel spreadsheet. For most people less scrolling, pointing and clicking of the mouse means you can work more efficiently. So if you ever wanted to learn some or all of the Excel keyboard shortcuts then this is the web page for you. It is unlikely that you'll be able to remember all of the Excel keyboard shortcuts below, so we recommend that you download the Excel file, print it out, and put it up at your desk. Over time and with regular use, the ones that best suit your needs will eventually become second nature to you.

Many people have also found that knowing some of these Excel keyboard shortcuts has helped make the transition from Excel 2003 to Excel 2007 a lot easier!

Click on the button below to begin download.

Our Microsoft Excel Templates are .xls files so they work on the following platforms:
Windows 2000, XP, Vista, Windows 7
Micorostf Excel 2000, 2002(XP), 2003, 2007, 2010

Key	Alone	Shift	Ctrl	Alt	Shift + Ctrl
F1	Help	What's This Help		Insert Chart Sheet
F2	Edit Mode	Edit Comment		Save As
F3	Paste Name Formula	Paste Function	Define Name		Names From Labels
F4	Repeat Action	Find Again	Close Window	Exit
F5	Goto	Find	Restore Window Size
F6	Next Pane	Prev Pane	Next Workbook		Prev Workbook
F7	Spell Check		Move Window
F8	Extend Selection	Add To Selection	Resize Window	Macro List
F9	Calculate All	Calculate Worksheet	Minimize Workbook
F10	Activate Menu	Context Menu	Restore Workbook
F11	New Chart	New Worksheet	New Macro Sheet	VB Editor
F12	Save As	Save	Open		Print

Key	Alone	Shift	Ctrl	Alt	Shift + Ctrl
A			Select All		Formula Arguments
B			Bold
C			Copy
D			Fill Down	Data Menu
E				Edit Menu
F			Find	File Menu	Font Name
G			Goto
H			Replace	Help Menu
I			Italics	Insert Menu
J
K			Insert Hyperlink
L
M
N			New Workbook
O			Open Workbook	Format Menu	Select Comments
P			Print		Font Size
Q
R			Fill Right
S			Save
T				Tools Menu
U			Underline
V			Paste
W			Close Workbook	Window Menu
X			Cut
Y			Repeat Active
Z			Undo

Key	Alone	Shift	Ctrl	Alt	Shift + Ctrl
` (~)			Toggle Formula View		General Format
1 (!)			Cell Format		Number Format
2 (@)					Time Format
3 (#)					Date Format
4 ($)					Currency Format
5 (%)			Strkethru		Percent Format
6 (^)					Exponent Format
7 (&)					Apply Border
*8 ()**			Outline		Select Region
9 (()			Hide Rows		Unhide Rows
0 ())			Hide Columns		Unhide Columns
- _			Delete Selection		No Border
= (+)	Formula			Auto Sum

Key	Alone	Shift	Ctrl	Alt	Shift + Ctrl
[			Direct Precedents		All Precedents
]			Direct Dependents		All Dependents
; :			Insert Date		Insert Time
"				Style	Copy Cell Value Above
/			Select Array
\			Select Row Differences		Select Column Differences
Insert	Insert Mode
Delete	Clear		Delete To End Of Line
Home	Begin Row		Start Of Worksheet
End	End Row		End Of Worksheet
Page Up	Page Up		Previous Worksheet	Left 1 screen
Page Down	Page Down		Next Worksheet	Right 1 screen
Left Arrow	Move Left	Select Left
Right Arrow	Move Right	Select Right
Up Arrow	Move Up	Select Up
Down Arrow	Move Down	Select Down
Space Bar	Space	Select Row	Select Column	Control Box
Tab	Move Right	Move Left	Next Window	Next Application	Previous Window
BackSpace			Goto Active Cell