Posted by: Jubin Sanghvi | July 9, 2009

Microsoft Excel Shortcut keys


A

Absolute/relative/mixed reference

F4
AutoSum Alt =

B

Bold

Ctrl-B
Border lines off Ctrl-Shift _
Border lines on Ctrl-Shift &

C

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

D

Date

Ctrl ;
Delete range Ctrl -
Delete to end of line Ctrl-Del
Show values/formulas Ctrl `

E

Edit cell

F2
Enter formula as array Ctrl-Shift-Enter

F

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 @
GoTo Ctrl-G
Group row/column Alt-Shift-Right

H

Hard Return in cell

Alt-Enter
Hide selected column(s) Ctrl-0 (zero)
Hide selected row(s) Ctrl-9

I

Insert chart sheet

F11
Insert Function components Ctrl-Shift-A
Insert range Ctrl-Shift-Plus
Insert worksheet Shift-F11
Italics Ctrl-I

M

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

N

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

O

Open

Ctrl-O
Outline symbols display/hide Ctrl-8

P

Paste

Ctrl-V
Paste named range (Insert/Name/Paste) F3
Previous window Ctrl-Shift-F6
Previous worksheet Ctrl-PgDn
Print Ctrl-P

R

Repeat Find

Shift-F4
Repeat/Redo Ctrl-Y
Replace Ctrl-H

S

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 ‘

T

Tab inserted

Ctrl-Alt-Tab
Time Ctrl-Shift-Colon

U

Underline

Ctrl-U
Undo Ctrl-Z
Ungroup row/column Alt-Shift-Left
Unhide column(s) Ctrl-Shift )
Unhide row(s) Ctrl-Shift (

Thanks.

From,

Jubin Sanghvi (Editor).


Leave a response

Your response:

Categories