Natchatran

NATCHATRAN

Natchatran Blogs includes Technical Tutorials, E-books, Notes, Lab Manual, Question Banks, Viva questions and Interview questions for engineering students, provides all study material for cse students.

-Natchatran(Prem Anandh.J)

Tuesday, June 4, 2013

MS Office Shortcut Key

MS Office Shortcut Key

Key
Alone
Shift
Ctrl
Alt
Shift Ctrl
F1
Help
What's This Help

Insert Chart Sheet

F2
Edit Mode
Edit Comment

Save As

F3
Paste Name Formula
Paste Function
Define Name

Names From Labels
F4
Repeat Action
Find Again
Close Window
Quit Excel
Find Previous
F5
Goto
Find
Restore Window Size


F6
Next Pane
Prev Pane
Next Window
Previous Window
Prev Workbook
F7
Spell Check

Move Window


F8
Extend Selection
Add To Selection
Resize Window
Macro List

F9
Calculate All
Calculate Worksheet
Minimize Workbook


F10
Activate Menu
Context Menu
Maximize Window


F11
New Chart
New Worksheet
New Macro Sheet
VB Editor

F12
Save As
Save
Open

Print
A


Select All 

Formula Arguments
B


Bold


C


Copy


D


Fill Down
Data Menu

E



Edit Menu

F


Find
File Menu
Font Name
G


Goto


H


Replace
Help Menu

I


Italics
Insert Menu

J





K


Insert  Hyperlink


L





M





N


New Workbook


O


Open Workbook
Format Menu
Select Comments
P


Print

Font Size
Q





R


Fill Right


S


Save


T



Tools Menu

U


Underline


V


Paste


W


Close Workbook
Window Menu

X


Cut


Y


Repeat Active


Z


Undo


` (~)


Toggle Formula View

General Format
1 (!)


Cell Format

Number Format
2 (@)


Toggle Bold

Time Format
3 (#)


Toggle Italics

Date Format
4 ($)


Toggle Underline

Currency Format
5 (%)


Toggle Strikethru

Percent Format
6 (^)


Toggle Object Display

Exponent Format
7 (&)


Show/Hide Standard Toolbar

Apply Border
8 (*)


Outline

Select Region
9 (()


Hide Rows

Unhide Rows
0 ())


Hide Columns

Unhide Columns
-


Delete Selection
Control Menu
No Border
= (+)
Formula

Calculate All
Auto Sum
Insert Cells
[


Direct Precendents

All Precendents
]


Direct Dependents

All Dependents
; (semicolon)


Insert Date
Select Visible Cells
Insert Time
' (apostrophe)


Copy Formula From Above
Style
Copy Value Above
: (colon)


Insert Time


/


Select Array

Select Array
\


Select Differences

Select Unequal Cells
Insert
Insert Mode

Copy


Delete
Clear

Delete To End Of Line


Home
Begin Row

Start Of Worksheet


End
End Row

End Of Worksheet


Page Up
Page Up

Previous Worksheet
Left 1 screen

Page Down
Page Down

Next Worksheet
Right 1 screen

Left Arrow
Move Left
Select Left
Move Left Area


Right Arrow
Move Right
Select Right
Move Right Area


Up Arrow
Move Up
Select Up
Move Up Area


Down Arrow
Move Down
Select Down
Move Down Area
Drop down list

Space Bar
Space
Select Row
Select Column
Control Box
Select All
Tab
Move Right
Move Left
Next Window
Next Application
Previous Window
Enter

Move Up
Fill Selection With Active Cell
Insert Row

BackSpace

Collapse Selection To
Active Cell
Goto Active Cell




No comments: