Short Keys

MS WORD SHORT KEY
Ctrl + N = New
Ctrl + O = Open
Ctrl + Alt +F2 = Open
Ctrl + S = Save
Shift + F12 = Save
F12 = Save As
Ctrl + P = Print
Ctrl + Shift +F12 = Print
Ctrl + F2 = Print Preview
Ctrl + Alt +I = Print Preview
Ctrl + W = Close Window
Alt + F4 = Close Program
Ctrl +F6 = Switch Window
Ctrl + F10 = Maximize& Restore Window
F1 = Help
Ctrl + F1 = Minimize & Maximize Window
Alt = Show Numbers
F6 = Switch Tabs
Home = Go To Line Start
End = Go To Line End
Ctrl + Home = Go To Document Start
Ctrl +End = Go To Document End
Left Arrow = Move Cursor Left 1 Character
Ctrl + Left Arrow= Move Cursor Left 1 Word
Right Arrow = Move Cursor Right 1 Character
Ctrl + Right Arrow= Move Cursor Right 1 Word
Up Arrow = Move Cursor 1 Line Up
Ctrl + Up Arrow = Move Cursor 1 Paragraph Up
Down Arrow = Move Cursor 1 Line Down
Ctrl + Down Arrow= Move Cursor 1 Paragraph Down
Backspace = Delete Cursor Left Character
Ctrl +Backspace = Delete Cursor Left Word
Delete = Delete Cursor Right Character
Ctrl + Delete = Delete Cursor Right Word
Page Up = Up On Page
Ctrl + Page Up = Start On Page
Page Down = Down Page
Ctrl + Page Down= Last Page
Enter = Change Line
Ctrl + Enter = Page Break
Ctrl+ Shift+ Enter= Column Break
Shift + F10 = Display Shortcut Menu
Ctrl + X = Cut
Ctrl+ C = Copy
Ctrl +V = Paste
Ctrl + Shift +C = Copy Format
Ctrl +Shift +V = Paste Format
Ctrl +Shift +F = Font
Ctrl +Shift +P = Font Size
Ctrl +> = Increase Font Size
Ctrl+< = Decrease Font Size
Ctrl+ B = Bold
Ctrl + I = Italic
Ctrl +U = Underline
Ctrl += = Subscript
Ctrl ++ = Superscript
Shift +F3 = Change Case
Ctrl +D = Font
Ctrl + Space = Clear Formatting
Ctrl +Shift +L = Bullet Style
Ctrl +L = Left Align
Ctrl +E = Center Align
Ctrl +R = Right Align
Ctrl +J = Justify
Ctrl +1 = Single Line Spacing
Ctrl +2 = Double Line Spacing
Ctrl +5 = 1.5 Line Spacing
Ctrl + M = Increase Indent
Ctrl + Shift+ M = Decrease Indent
Ctrl +* = Show/hide
Ctrl + Alt +1 = Changes text to Heading 1
Ctrl + Alt +2 = Changes text to Heading 2
Ctrl + Alt +3 = Changes text to Heading 3
Ctrl + Shift + N = Normal Style
Ctrl +Alt +Shift +S= Style
Ctrl+ Shift + S = Apply Style
Ctrl +F = Find
Shift + F4 = Find
Ctrl + Alt + Y = Find Next
Ctrl +H = Replace
F5 = Go To
Ctrl +G = Go To
Ctrl + A = Select All
Ctrl + Enter = Page Break
Ctrl +K = Hyperlink
Ctrl + Shift + F5 = Bookmark
Alt + = = Equation
Ctrl + Shift + Enter= Column Break
F9 = Update Table
Alt +Ctrl+ F = Footnote
Alt + Ctrl +D = Endnote
Alt + Shift +X = Mark Entry
Alt + Shift + I = Mark Citation
F7 = Spelling & Grammar Checking
Alt + Click = Research
Ctrl + Shift + O = Research
Shift + F7 = Thesaurus
Alt + Ctrl + M = New Comment
Ctrl + Shift +E = Track Change
Ctrl + Shift + G = Word Count
Alt + Ctrl + P = Print Layout
Alt +Ctrl + O = Outline
Alt + Ctrl + N = Draft
Ctrl + Alt + S = Split Window
Alt + Shift + C = Remove Split

Excel Short Keys

Navigate Inside Worksheet

Up Arrow            -              Move one cell up

Down Arrow      -              Move one cell Down

Left Arrow          -              Move one cell Left

Right Arrow        -              Move one cell Right

Home                    -Move to the beginning row

 Ctrl +Home        -              Move to the beginning worksheet

Ctrl + End - Move to the last cell with content

Ctrl + UP              -              Go to First Row

Ctrl + Down        -              Go to Last Row

Ctrl + Left            -              Go to First Column

Ctrl + Right          -              Go to Last Column

Page Up               -              Move one screen up

Page Down         -              Move one Screen Down

Alt+ Page Up      -              Move One Screen Left

Alt + Page Down-             Move One Screen Right

Tab                         -              Move one cell Right

Shift+ Tab            -              Move one cell Left

Alt + Down Arrow-          Auto Complete List

Selection

Shift + Space      -              Select Entire Row

Ctrl + Space        -              Select Entire Column

Ctrl + A                 -              Select All

Ctrl + *                  -              Select Current Region around the active cell

Ctrl + Shift +O    -Select Comment with Cell

Shift + Up Arrow -            Select one cell up

Shift + Down Arrow-       Select One cell Down

Shift + Right Arrow -       Select One Cell Right

Shift + Left Arrow-           Select One Cell Left

Enter                     -              Move Active Cell Down

Shift + Enter       -              Move Active Cell Up

Tab                         -              Move one Cell Right

Shift + Tab           -              Move one Cell Left

Ctrl + Shift + Home          -              Extend selection to the beginning of the row

Ctrl +Shift + End                                -              Extend Selection to the last used cell on the worksheet

Shift + Page up                  -              Extend the selection to down one screen

Shift + Page Down           -              Extend the selection to up one screen

Ctrl + Shift + Page Up     -              Select the current and previous sheet in a worksheet

Ctrl + Shift + Page Down               -              Select Current and next sheet in a worksheet

Esc                          -              Cancel Selection/ Cancel Entry

Manage Active Selection

F8                           -              Turn on extension of selection with arrow keys without having to keep pressing shift

Shift + F8             -              Add another reange of cell to the selection. Use arrow keys and shift + arrow  keys to add to selection.

F2                           -              Edit Active Cell

File Menu

Ctrl + N                 -              New Worksheet

Ctrl + O                 -              Open

Ctrl +S                   -              Save

F12                         -              Save As

Ctrl + F2                -              Print Preview

Ctrl + P                  -              Print

Ctrl + W                -              Close Workbook

Alt + F4                 -              Close Program

F1                           -              Help

Ctrl + F1                -              Minimize & Maximize Window

Ctrl + Z                  -              Undo

Ctrl +Y                   -              Redo

Ctrl + F9                -              Minimize workbook

Ctrl + F10             -              Maximize Workbook

Shift + F10           -              Right Click

Home

Ctrl + X                  -              Cut

Ctrl + C                  -              Copy

Ctrl + V                 -              Paste

Ctrl + Alt + V       -              Paste Special

Ctrl + Shift + F    -              Font Dialog box

Ctrl + Shift + P    -              Font Dialog box

Ctrl + 1                  -              Format Cells Dialog box

Ctrl + B  (Ctrl + 2) -            Bold

Ctrl + I (Ctrl +3)  -              Italic

Ctrl + U (Ctrl +4) -             Underline

Ctrl + 5                  -              Strikethrough

Ctrl + Shift+&-                   Apply outline border

Ctrl + Shift+_ -           Remove outline borders

Alt + T*                 -              Set top border

Alt+ B*                 -              Set bottom Border

Alt+ L*                  -              Set left Border

Alt+ R*                 -              Set right Border

Alt+ D*                 -              Set diagonal and down border

Alt+ U*                 -              Set diagonal and up border

Ctrl+Shift+$  -           Currency format

Ctrl+Shift+~  -           General number format.

Ctrl+Shift+% -           Percentage

Ctrl+Shift+#              -           Date format with the day, month, and year.

Ctrl+Shift+@ -           Apply the Time format with the hour and minute, and indicate A.M. or P.M.

Ctrl+Shift+!   -           Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

Ctrl+Shift+^  -           Apply the Scientific number format with two decimal places.

Ctrl + L           -           Format Table

Alt +’               -           Style Dialog box

Ctrl + Shift ++  -       Insert Cell/Row/Column

Shift + F11     -           Insert Sheet

Ctrl +-             -           Delete Cell/Row/Column

Alt+HDS         -           Delete Current Sheet

Alt +ore          -           Row Hight

Alt+ora           -           Row hight to fit content

Alt+ocw          -           Column Width

Alt +oca          -           Adjust Column to fit content

Ctrl+9             -           Hide Selected Row

Ctrl + Shift+9                        -           Unhide Row

Ctrl + 0                       -           Hide Select Column

Ctrl + -                        -           Unhide Column

Alt+HOR                    -           Rename Sheet

Alt +e then m            -           Move woksheet

Alt + HOP                   -           Protect Sheet

Alt + =                        -           Auto Sum

Ctrl + D                      -           Copy Above Cell

Ctrl + R                       -           Copy left cell

Ctrl + ‘                        -           Copy above cell formula

Ctrl + Shift + L          -           Filter

Ctrl + Find

Ctrl + H                      -           Replace

Ctrl + A                       -           Select All

F5/Ctrl + G                 -           Go to

F11                              -           Insert Chart

Ctrl + K                       -           Hyperlink

=                                 -           Start Formula

Alt+=                          -           Auto Sum

Shift + F3                   -           Insert Function

Ctrl+;                          -           Insert Current Date

Ctrl + :                        -           Insert Current Time

Ctrl +F3                      -           Name Manager

Ctrl +`                         -           Show Formulas

F9                                -           Calculate Now

Shift+F9                     -           Calculate Sheet

Ctrl +Alt+U                -           Expend & Collapse Formula Bar

Ctrl + Alt + F5           -           Refresh All

Shift+Alt+Right         -           Group

Shift+Alt+Left           -           Ungroup

F7                                -           Spelling & Grammar Check

Alt+Click                    -           Research

Shift+F7                     -           Thesaurus

Shift +F2                    -           Comment

Ctrl +Shif+O              -           Select All Comment

Yogesh Ghotra

Funny Picture