to be myself

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 (