Microsoft Excel Shortcut Keys

Absolute/relative/mixed reference	F4
AutoSum	Alt =
Bold	Ctrl-B
Border lines off	Ctrl-Shift _
Border lines on	Ctrl-Shift &
Calculate active sheet	Shift-F9
Calculate all worksheets	F9
Close	Ctrl-W
Collapse selection to active cell	Shift-Backspace
Comment insert/edit	Shift-F2
Copy	Ctrl-C
Copy formula from cell above	Ctrl '
Copy value from cell above	Ctrl-Shift "
Cut	Ctrl-X
Date	Ctrl ;
Delete range	Ctrl -
Delete to end of line	Ctrl-Del
Show values/formulas	Ctrl `
Edit cell	F2
Enter formula as array	Ctrl-Shift-Enter
Fill down	Ctrl-D
Fill right	Ctrl-R
Find	Ctrl-F
Format commas (2 decimal places)	Ctrl-Shift!
Format currency (2 decimal places)	Ctrl-Shift $
Format date (day, month, year)	Ctrl-Shift #
Format exponential number (2 decimal places)	Ctrl-Shift ^
Format general number	Ctrl-Shift ~
Format percentage (0 decimal places)	Ctrl-Shift %
Format time (hour and minute)	Ctrl-Shift @
Formula	=
Function Wizard	Shift-F3
GoTo	Ctrl-G
Group row/column	Alt-Shift-Right
Hard Return in cell	Alt-Enter
Hide selected column(s)	Ctrl-0 (zero)
Hide selected row(s)	Ctrl-9
Insert chart sheet	F11
Insert Function components	Ctrl-Shift-A
Insert range	Ctrl-Shift-Plus
Insert worksheet	Shift-F11
Italics	Ctrl-I
Menu bar	F10
Move between noncontiguous selections	Ctrl-Alt-Left/Right
Move left/right one screen	Alt-PgUp/PgDn
Move to beginning of worksheet	Ctrl-Home
Move to edge of region	Ctrl-Arrow
Move to end of row	End, Enter
Move to end of worksheet	Ctrl-End
Move to next corner of selection	Ctrl .
Move up through a selection	Shift-Enter
Name a range (Insert/Name/Create)	Ctrl-Shift-F3
Name a range (Insert/Name/Define)	Ctrl-F3
New	Ctrl-N
Next window	Ctrl-F6
Next worksheet	Ctrl-PgUp
Open	Ctrl-O
Outline symbols display/hide	Ctrl-8
Paste	Ctrl-V
Paste named range (Insert/Name/Paste)	F3
Previous window	Ctrl-Shift-F6
Previous worksheet	Ctrl-PgDn
Print	Ctrl-P
Repeat Find	Shift-F4
Repeat/Redo	Ctrl-Y
Replace	Ctrl-H
Save	Ctrl-S
Save As	F12
Scroll to display active cell	Ctrl-Backspace
Select array to which active cell belongs	Ctrl /
Select cells directly referred to by selected formula	Ctrl [
Select cells referred to by selected formula	Ctrl-Shift {
Select cells with comments	Ctrl-Shift ?
Select column	Ctrl-spacebar
Select current region	Ctrl-Shift *
Select formulas that directly refer to active cell	Ctrl ]
Select formulas that refer to active cell	Ctrl-Shift }
Select objects on worksheet	Ctrl-Shift-spacebar
Select row	Shift-spacebar
Select to beginning of row	Shift-Home
Select to beginning of worksheet	Ctrl-Shift-Home
Select to edge of region	Ctrl-Shift-(Arrow)
Select to end of row	End, Shift-Enter
Select to end of worksheet	Ctrl-Shift-End
Select visible cells in selection	Alt ;
Select worksheet	Ctrl-A
Shortcut menu	Shift-F10
Spelling and Grammar check	F7
Strikethrough on/off	Ctrl-5
Style box	Alt '
Tab inserted	Ctrl-Alt-Tab
Time	Ctrl-Shift-Colon
Underline	Ctrl-U
Undo	Ctrl-Z
Ungroup row/column	Alt-Shift-Left
Unhide column(s)	Ctrl-Shift )
Unhide row(s)	Ctrl-Shift (