New file

Ctrl + N

Open file

Ctrl + O

Save file

Ctrl + S

Move between open workbooks

Ctrl + F6

Close file

Ctrl + F4

Save as

F12

Display the print menu

Ctrl + P

Select whole spreadsheet

Ctrl + A

Select column

Ctrl + Space

Select row

Shift + Space

Undo last action

Ctrl + Z

Redo last action

Ctrl + Y

Start a formula

Equals Sign (eg. SUM(A1+A2)

Exit Excel 97

Alt + F4

Move to next cell in row

Tab

Move to previous cell in row

Shift + Tab

Up one screen

Page Up

Down one screen

Page Down

Move to next worksheet

Ctrl + Page Down

Move to previous worksheet

Ctrl + Page Up

Go to first cell in data region

Ctrl + Home

Go to last cell in data region

Ctrl + End

Bold toggle for selection

Ctrl + B

Italic toggle for selection

Ctrl + I

Underline toggle for selection

Ctrl + U

Strikethrough for selection

Ctrl + 5

Change the font

Ctrl + Shift + F

Change the font size

Ctrl + Shift + P

Apply outline borders

Ctrl + Shift + 7

Remove all borders

Ctrl + Shift + Underline

Wrap text in same cell

Alt + Enter

Format cells

Ctrl + 1

Select font

Ctrl + Shift + F

Select point size

Ctrl + Shift + P

Format as currency

Ctrl + Shift + 4

Format as general
(to remove any formatting)

Ctrl + Shift + # (hash sign)

Format as percentage

Ctrl + Shift + 5

Format as number

Ctrl + Shift + 1

Delete one character to right

Delete

Delete one character to left

Backspace

Edit active cell

F2

Cancel cell entry

Escape Key

Select entire worksheet

Ctrl + A

Select entire row

Shift + Spacebar

Select entire column

Ctrl + Spacebar

Manual select

Hold Shift + with Left, Right, Up, Down Arrow Key

Cut

Ctrl + X

Copy

Ctrl + C

Paste

Ctrl + V

Autosum a range of cells

Alt + Equals Sign

Insert the date

Ctrl + ; (semi-colon)

Insert the time

Ctrl + Shift + ; (semi-colon)

Insert columns/rows

Ctrl + Shift + + (plus sign)

Insert a new worksheet

Shift + F11

Find text

Ctrl + F

Replace text dialog

Ctrl + H

Create a chart automatically on new sheet

F11

Edit a cell comment

Shift + F2

Say Version of Excel

Ctrl + Shift + V

Move to Next Sheet

Ctrl + Page Down

Move to Prior Sheet

Ctrl + Page Up

Go to a cell command

Ctrl + G

Collapse Selection To Active Cell

Shift + Backspace

Say Active Cell Coordinates

Insert + C

AutoSum

Alt + Equals

Formula Mode

Equals Sign

Insert Date In Current Cell

Ctrl + ; (semicolon)

Insert Time In Current Cell

Ctrl + Shift + ; (semicolon)

Current Column First Cell From Top

Alt + 1

Current Column Second Cell From Top

Alt + 2

Current Column Third Cell From Top

Alt + 3

Current Column Fourth Cell From Top

Alt + 4

Data Region Left

Ctrl + Left Arrow

Data Region Right

Ctrl + Right Arrow

Data Region Down

Ctrl + Down Arrow

Data Region Up

Ctrl + Up Arrow

Select Whole Data Region

Ctrl + Shift + 8

Say Formula

Ctrl + F2

Spell Check

F7

Report Gridline Status

Alt + Shift + g

Read Row Total

Insert + Delete

Read Column Total

Insert + Enter

Say Column Title

Alt + Shift + C

Say Row Title

Alt + Shift + R

Say Visible Range Coordinates

Alt + Shift + V

Cycle Through Controls in Dialog Box

Tab

Tab Backwards

Shift + Tab

List Cells With Comments

Ctrl + Shift + ' (apostrophe)

Row Second Cell From Left

Alt + Ctrl + 2

Row First Cell From Left

Alt + Ctrl + 1

Row Third Cell From Left

Alt + Ctrl + 3

Row Fourth Cell From Left

Alt + Ctrl + 4

Describe Cell Border

Alt + Shift + B

Read Cell Comment

Alt + Shift + ' (apostrophe)

Auto Filter

Ctrl + Shift + A

Read Cell Hyperlink

Alt + Shift + H

Close Office Assistant

Ctrl + Insert + F4

Set Monitor Cell One

Alt + Ctrl + Shift + 1

Set Monitor Cell Two

Alt + Ctrl + Shift + 2

Set Monitor Cell Three

Alt + Ctrl + Shift + 3

Set Monitor Cell Four

Alt + Ctrl + Shift + 4

Set Monitor Cell Five

Alt + Ctrl + Shift + 5

Set Monitor Cell Six

Alt + Ctrl + Shift + 6

Set Monitor Cell Seven

Alt + Ctrl + Shift + 7

Set Monitor Cell Eight

Alt + Ctrl + Shift + 8

Set Monitor Cell Nine

Alt + Ctrl + Shift + 9

Set Monitor Cell 10

Alt + Ctrl + Shift + 0

Read Monitor Cell One

Alt + Shift + 1

Read Monitor Cell Two

Alt + Shift + 2

Read Monitor Cell Three

Alt + Shift + 3

Read Monitor Cell Four

Alt + Shift + 4

Read Monitor Cell Five

Alt + Shift + 5

Read Monitor Cell Six

Alt + Shift + 6

Read Monitor Cell Seven

Alt + Shift + 7

Read Monitor Cell Eight

Alt + Shift + 8

Read Monitor Cell Nine

Alt + Shift + 9

Read Monitor Cell Ten

Alt + Shift + 0

List Visible Cells With Data

Ctrl + Shift + D

Lists Data In Current Column

Ctrl + Shift + C

List Data In Current Row

Ctrl + Shift + R

Select Hyperlink

Ctrl + Shift + H

Move To Worksheet Listbox

Ctrl + Shift + S

Move To Monitor Cell

Ctrl + Shift + M

Select Worksheet Objects

Ctrl + Shift + O

List Cells At Page Breaks

Ctrl + Shift + B

Options Listbox

Insert + V