Microsoft Excel Keyboard Keys

Microsoft Excel Keyboard Keys Source:

General

Description New file Open file Save file Move between open workbooks Close file Save as Display the print menu Select whole spreadsheet Select column Select row Undo last action Redo last action Start a formula Exit Excel 97

Shortcut Key Ctrl + N Ctrl + O Ctrl + S Ctrl + F6 Ctrl + F4 F12 Ctrl + P Ctrl + A Ctrl + Space Shift + Space Ctrl + Z Ctrl + Y Equals Sign (eg. SUM(A1+A2) Alt + F4

Navigating

Description Move to next cell in row Move to previous cell in row Up one screen Down one screen Move to next worksheet Move to previous worksheet Go to first cell in data region Go to last cell in data region

Formatting Text In Worksheet

Description Bold toggle for selection Italic toggle for selection Underline toggle for selection Strikethrough for selection Change the font Change the font size

Shortcut Key Tab Shift + Tab Page Up Page Down Ctrl + Page Down Ctrl + Page Up Ctrl + Home Ctrl + End

Shortcut Key Ctrl + B Ctrl + I Ctrl + U Ctrl + 5 Ctrl + Shift + F Ctrl + Shift + P

Apply outline borders

Ctrl + Shift + 7

Remove all borders

Ctrl + Shift + Underline

Wrap text in same cell

Alt + Enter

Formatting Cells

Description

Shortcut Key

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

Editing/Deleting Text

Description

Shortcut Key

Delete one character to right

Delete

Delete one character to left

Backspace

Edit active cell

F2

Cancel cell entry

Escape Key

Highlighting Cells

Description Select entire worksheet Select entire row Select entire column Manual select

Copying and Moving Text

Description Cut Copy Paste

Inserting Text Automatically

Description Autosum a range of cells Insert the date Insert the time Insert columns/rows

Shortcut Key Ctrl + A Shift + Spacebar Ctrl + Spacebar Hold Shift + with Left, Right, Up, Down Arrow Key

Shortcut Key Ctrl + X Ctrl + C Ctrl + V

Shortcut Key Alt + Equals Sign Ctrl + ; (semi-colon) Ctrl + Shift + ; (semi-colon) Ctrl + Shift + + (plus sign)

Insert a new worksheet

Misc

Description Find text Replace text dialog Create a chart automatically on new sheet Edit a cell comment

Main Jaws Keystrokes In Excel

Description Say Version of Excel Move to Next Sheet Move to Prior Sheet Go to a cell command Collapse Selection To Active Cell Say Active Cell Coordinates AutoSum Formula Mode Insert Date In Current Cell

Shift + F11

Shortcut Key Ctrl + F Ctrl + H F11 Shift + F2

Shortcut Key Ctrl + Shift + V Ctrl + Page Down Ctrl + Page Up Ctrl + G Shift + Backspace Insert + C Alt + Equals Equals Sign Ctrl + ; (semicolon)

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download