Monday 25 January 2010

Microsoft Excel Shortcuts



General


Description                                                           Shortcut Key

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

Navigating

Description                                                      Shortcut Key

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

Formatting Text In Worksheet

Description                                                 Shortcut Key

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

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                                     Shortcut 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

Copying and Moving Text

Description                                   Shortcut Key

Cut                                              Ctrl + X

Copy                                           Ctrl + C

Paste                                           Ctrl + V

Inserting Text Automatically

Description                                Shortcut Key

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

Misc

Description                                                 Shortcut Key

Find text                                                      Ctrl + F

Replace text dialog                                      Ctrl + H

Create a chart automatically on new sheet        F11

Edit a cell comment                                      Shift + F2

Main Jaws Keystrokes In Excel

Description                                                        Shortcut Key

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







                                                      http://syedimranrocks.blogspot.in/

No comments:

Post a Comment