Tuesday, March 22, 2011

SHORTCUTS OF MICROSOFT OFFICE

 

30 shortcuts of Microsoft Excel


Select the current column [Ctrl] + [Space]

Select the current row [Shift] + [Space]

Edit the active cell [F2]

Move to the beginning of the worksheet [Ctrl] + [Home]

Move to the last cell on the worksheet [Ctrl] + [End]

Paste a name into a formula [F3]

Paste a function into a formula [Shift] + [F3]

Alternate value/formula view [Ctrl] + [`]
(on key [1])

Calculate all sheets in all open workbooks [F9]

Display the Go To dialog box [F5]

Display the Find dialog box [Shift] + [F5]

Display the Format Cells dialog box [Ctrl] + [1]

Create a chart [F11]

Insert a new sheet [Alt] + [Shift] + [F1]

Repeat the last action [F4]

Repeat Find [Shift] + [F4]

Open [Ctrl] + [F12]

Exit [Ctrl] + [F4]

Check spelling of current cell [F7]

Activate the menu bar [F10]

Display the Macro dialog box [Alt] + [F8]

Apply outline to active cell [Ctrl] + [Shift] + [&]

Convert to a percentage [Ctrl] + [Shift] + [%]

Select all filled cells around active cell [ctrl] + [Shift] + [*]

Move to next sheet [Ctrl] + [Page Down]

Move to previous sheet [Ctrl] + [Page Up]

Complete a cell entry and move up [Shift] + [Enter]

Complete a cell entry and move right [Tab]

Complete a cell entry and move left [Shift] + [Tab]

Edit a cell comment [Shift] + [F2]



Outlook shortcuts

Five email shortcuts:
.
Display Inbox [Ctrl] + [Shift] + [I]

Check for new mail [F5]

Reply to selected mail [Ctrl] + [R]

Create new mail [Ctrl] + [N]

Send mail [Ctrl] + [Enter]

Publisher shortcuts


Five essential DTP shortcuts:

Toggle frame opacity [Ctrl] + [T]

Nudge frame [Alt] + [Arrow]
(any of the four directions)

Format copy [Ctrl] + [Shift] + [C]

Format paste [Ctrl] + [Shift] + [V]

Toggle current/actual page view [F9]

PowerPoint shortcuts


Five shortcuts to increase your speed:

Insert slide [Ctrl] + [M]

Move to the next pane [F6]

Move to the previous pane [Shift] + [F6]

Insert a hyperlink [Ctrl] + [K]

Start slide show [F5]

Generic shortcuts

These shortcuts work in all Office applications, as well as some third-party software.

Open [Ctrl] + [O]

Exit [Alt] + [F4]

Save [Ctrl] + [S]

Print [Ctrl] + [P]

Select All [Ctrl] + [A]

Cut [Ctrl] + [X]

Copy [Ctrl] + [C]

Paste [Ctrl] + [V]

Undo [Ctrl] + [Z]

Redo [Ctrl] + [Y]

Help [F1]

Open pop-up menu [Shift] + [F10]

Open window control menu [Alt] + [Space]

Scroll one page length down [Page Down]

Scroll one page length up [Page Up]

Delete [Delete]

Switch applications [Alt] + [Tab]

Activate menus [F10]

Close menu [Alt]

Select first/last menu item [Home]/[End]

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews