Friday, August 26, 2011

Microsoft Excel Keyboard Shortcuts

Shortcut Description
F2 Edit the selected cell.
F5 Goto a specific cell. For example, C6.
F7 Spell check selected text and/or document.
F11 Create chart.
Ctrl + A Select all.
Ctrl + B Bold.
Ctrl + C Copy.
Ctrl + F Find (same as Shift + F5).
Ctrl + G Go To.
Ctrl + H Replace.
Ctrl + I Italic.
Ctrl + K Insert link.
Ctrl + N New Workbook.
Ctrl + O Open Workbook.
Ctrl + P Print dialog.
Ctrl + S Save.
Ctrl + U Underline.
Ctrl + V Paste.
Ctrl + Z Undo.
Ctrl + Y Redo.
Ctrl + X Cut.
Ctrl + 5 Strikethrough text.
Ctrl + F3 Define Name.
Ctrl + F4 Exit Excel.
Ctrl + F6 Switch between open workbooks.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize current window.
Shift + F1 Activate Help on Item.
Shift + F2 Insert Comments
Shift + F3 Insert Function.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Ctrl + Page down Move to next worksheet.
Ctrl + Page up Move to previous worksheet.
Ctrl + Shift + # Number Format: Date
Ctrl + Shift + @ Number Format: Time.
Ctrl + Shift + ! Number Format: Commas.
Ctrl + Shift + $ Number Format: Currency
Ctrl + Shift + % Number Format: Percentage
Ctrl + Shift + ^ Number Format: Scientific.
Ctrl + Space Select entire column.
Shift + Space Select entire row.
Ctrl + (Arrow key) Move to next section.

Thursday, August 25, 2011

Microsoft Excel World Champion

A 15 years old British schoolgirl is the new "Microsoft Excel World Champion"

A 15 years old British school girl Rebecca Rickwood has won a global competition to find the best user of Microsoft’s Excel 2007. 

Rebecca, who is 15, was one of 228,000 competitors from 57 countries. She beat 78 students in the final round. Competitors were required to perform timed tests to demonstrate their skill at making spreadsheets. Rebecca was presented with her $5000 prize last week at a ceremony in San Diego, California.

Competitors performed timed tests to demonstrate their skill at making spreadsheets, reports the BBC, and Rebecca Rickwood, 15, clinched the $5,000 (around £3,000) prize in the Excel 2007 category of the Microsoft Office World Championships without making a single mistake.

She said: “I heard my name read out in first place and I just couldn’t believe it. I’m ecstatic, I just can’t believe I won and now I’m world champion. It’s a day I’ll never forget.”

Rebecca is a pupil at Sawtry Community College, Cambridgeshire, a specialist maths and computing secondary school.


Monday, August 22, 2011

How to Make Windows XP Shut Down Faster

One of the biggest annoyances in Windows XP is to take a long time to Shut Down.
If you want shut it down faster, Please follow these steps:



1. Go to "StartStart Menu" then select "RUN"

2. Type "regedit" and click "OK"




3. Find "HKEY_CURRENT_USER\Control Panel\Desktop"

4. Select "HungAppTimeout"

5. Right click and select modify

6. Change the value to 5000 to 1000.

7. Now scroll down to

"WaitToKillAppTimeout"

8. Change the value to 20000 to 1000.






9. Now Find "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control"  

10. Select "WaitToKillAppTimeout"

11. Change the value to 1000

12. Now Find "HKEY_USERS\DEFAULT\Control Panel\Desktop"

13. Change "HungAppTimeout" value to 1000

14. At last scroll down and change "WaitToKillAppTimeout" value to 1000

15. Close Registry Editor and Restart Windows.