Thursday, September 27, 2007

MicroSoft-Excel

F1
Help

F2
Edit Mode

F3
Paste Name Formula

F4
Repeat Action

F5
Goto

F6
Next Pane

F7
Spell Check

F8
Extend Selection

F9
Calculate All

F10
Activate Menu

F11
New Chart

F12
Save As

= (+)
Formula

Insert
Insert Mode

Delete
Clear

Home
Begin Row

End
End Row

Page Up
Page Up

Page Down
Page Down

Left Arrow
Move Left

Right Arrow
Move Right

Up Arrow
Move Up

Down Arrow
Move Down

Space Bar
Space

Tab
Move Right

Shift + F1
What's This Help

Shift + F2
Edit Comment

Shift + F3
Paste Function

Shift + F4
Find Again

Shift + F5
Find

Shift + F6
Prev Pane

Shift + F8
Add To Selection

Shift + F9
Calculate Worksheet

Shift + F10
Context Menu

Shift + F11
New Worksheet

Shift + F12
Save

Shift + Left Arrow
Select Left

Shift + Right Arrow
Select Right

Shift + Up Arrow
Select Up

Shift + Down Arrow
Select Down

Shift + Space Bar
Select Row

Shift + Tab
Move Left

CTRL + F3
Define Name

CTRL + F4
Close Window

CTRL + F5
Restore Window Size

CTRL + F6
Next Workbook

CTRL + F7
Move Window

CTRL + F8
Resize Window

CTRL + F9
Minimize Workbook

CTRL + F10
Restore Workbook

CTRL + F11
New Macro Sheet

CTRL + F12
Open

CTRL + A
Select All

CTRL + B
Bold

CTRL + C
Copy

CTRL + D
Fill Down

CTRL + F
Find

CTRL + G
Goto

CTRL + H
Replace

CTRL + I
Italics

CTRL + K
Insert Hyperlink

CTRL + N
New Workbook

CTRL + O
Open Workbook

CTRL + P
Print

CTRL + R
Fill Right

CTRL + S
Save

CTRL + U
Underline

CTRL + V
Paste

CTRL + W
Close Workbook

CTRL + X
Cut

CTRL + Y
Repeat Active

CTRL + Z
Undo

CTRL + ` (~)
Toggle Formula View

CTRL + 1 (!)
Cell Format

CTRL + 2 (@)
Toggle Bold

CTRL + 3 (#)
Toggle Italics

CTRL + 4 ($)
Toggle Underline

CTRL + 5 (%)
Toggle Strikethru

CTRL + 8 (*)
Outline

CTRL + 9 (()
Hide Rows

CTRL + 0 ())
Hide Columns

CTRL + -
Delete Selection

CTRL + [
Direct Dependents

CTRL + ]
All Dependents

CTRL + ; (semicolon)
Insert Date

CTRL + : (colon)
Insert Time

CTRL + /
Select Array

CTRL + \
Select Differences

CTRL + Insert
Copy

CTRL + Delete
Delete To End Of Line

CTRL + Home
Start Of Worksheet

CTRL + End
End Of Worksheet

CTRL + Page Up
Previous Worksheet

CTRL + Page Down
Next Worksheet

CTRL + Left Arrow
Move Left Area

CTRL + Right Arrow
Move Right Area

CTRL + Up Arrow
Move Up Area

CTRL + Down Arrow
Move Down Area

CTRL + Space Bar
Select Column

CTRL + Tab
Next Window

CTRL + BackSpace
Goto Active Cell

ALT + F1
Insert Chart Sheet

ALT + F2
Save As

ALT + F4
Quit Excel

ALT + F6
Switch To VBA

ALT + F8
Macro List

ALT + F11
VB Editor

ALT + D
Data Menu

ALT + E
Edit Menu

ALT + F
File Menu

ALT + H
Help Menu

ALT + I
Insert Menu

ALT + O
Format Menu

ALT + T
Tools Menu

ALT + W
Window Menu

ALT + -
Control Menu

ALT + = (+)
Auto Sum

ALT + ; (semicolon)
Select Visible Cells

ALT + ' (apostrophe)
Style

ALT + Page Up
Left 1 screen

ALT + Page Down
Right 1 screen

ALT + Down Arrow
Drop down list

ALT + Space Bar
Control Box

ALT + Tab
Next Application

Shift + Ctrl + F3
Names From Labels

Shift + Ctrl + F6
Prev Workbook

Shift + Ctrl + F12
Print

Shift + Ctrl + A
Formula Arguments

Shift + Ctrl + F
Font Name

Shift + Ctrl + O
Select Comments

Shift + Ctrl + P
Font Size

Shift + Ctrl + ` (~)
General Format

Shift + Ctrl + 1 (!)
Number Format

Shift + Ctrl + 2 (@)
Time Format

Shift + Ctrl + 3 (#)
Date Format

Shift + Ctrl + 4 ($)
Currency Format

Shift + Ctrl + 5 (%)
Percent Format

Shift + Ctrl + 6 (^)
Exponent Format

Shift + Ctrl + 7 (&)
Apply Border

Shift + Ctrl + 8 (*)
Select Region

Shift + Ctrl + 9 (()
Unhide Rows

Shift + Ctrl + 0 ())
Unhide Columns

Shift + Ctrl + -
No Border

Shift + Ctrl + = (+)
Insert dialog

Shift + Ctrl + [
Direct Precedents

Shift + Ctrl + ]
All Precedents

Shift + Ctrl + ; (semicolon)
Insert Time

Shift + Ctrl + ' (apostrophe)
Copy Cell Value Above

Shift + Ctrl + /
Select Array

Shift + Ctrl + \
Select Unequal Cells

Shift + Ctrl + Space Bar
Select All

Shift + Ctrl + Tab
Previous Window

No comments: