Excel Shortcut Keys

Excel Shortcuts

Posted on Updated on

blog-excel-logo

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 (

 

Microsoft_Word_logo     Outlook_logo_and_wordmark.svg       download

 

 

 

Advertisements