Excel Shortcuts

Save over 60 minutes everyday using these simple excel shortcuts. Value your time! 

Function	Short-Cut Key
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 cell or range  (Format Cells dialog box)	Ctrl-1
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-Dn, Up, Left, Right
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 (