Mginger

Thursday, July 12, 2007

Shortcuts for MS Excel - Very Useful

----------------------------------
Today's Jokes
---------------------------------


Santa was caught for speeding and went before the judge.
The judge: What'll you take 30 days or Rs 3000.
Santa: I think I'll take the money.


*****

Q: How do you recognize Santa's son, Pappu, in School?
A: He is the one who erases the books when the teacher erases the board.


*****

Santa & Banta got tired of mobile & decide 2 use pigeons.
1day a pigeon reaches Banta without message.
Angry Banta calls Santa!
Santa: Oye, this was a missed call

*****


Manmohan Singh to Bush – We are sending Indians to the moon next year.
Bush – Wow! How Many?
Manmohan Singh - 100
25 - OBC
25 - SC
20 - ST
5 - Handicapped
5 - Sports Persons
5 - Terrorist Affected
5 - Kashmiri Migrants
9 - Politicians
and if possible
1 – Astronnaut

MS EXCEL Shortcuts

Note: A plus sign indicates that the keys need to be pressed at the same time.



Action : Keystroke

Document actions

Open a file : CTRL+O

New file : CTRL+N

Save As: F12

Save : CTRL+S

Print : CTRL+P

Find : CTRL+F

Replace : CTRL+H

Go to : F5


Cursor Movement


One cell up : up arrow

One cell down : down arrow

One cell right : Tab

One cell left : SHIFT+Tab

Top of worksheet (cell A1) : CTRL+Home

End of worksheet(last cell with data): CTRL+End

End of row : Home

End of column : CTRL+left arrow

Move to next worksheet : CTRL+PageDown

Formulas

Apply AutoSum : ALT+=

Current date : CTRL+;

Current time : CTRL+:

Spelling : F7

Help : F1

Macros: ALT+F8


Action : Keystroke

Selecting Cells

All cells left of current cell : SHIFT+left arrow

All cells right of current cell : SHIFT+right arrow

Entire column : CTRL+Spacebar

Entire row : SHIFT+Spacebar

Entire worksheet : CTRL+A


Text Style

Bold : CTRL+B

Italics : CTRL+I

Underline : CTRL+U

Strikethrough : CTRL+5


Formatting

Edit active cell : F2

Format as currency with 2 decimal places : SHIFT+CTRL+$

Format as percent with no decimal places : SHIFT+CTRL+%

Cut : CTRL+X

Copy: CTRL+C

Paste : CTRL+V

Undo: CTRL+Z

Redo : CTRL+Y

Format cells dialog box : CTRL+1

No comments: