October 8th, 2009
Enhance your productivity by using the Excel Shortcut Keys.
| General |
| Ctrl N |
New File |
| Ctrl O |
Open File |
| Ctrl S |
Save File |
| F12 |
Save As |
| Ctrl F4 |
Close File |
| Ctrl P |
Display Print Dialog |
| Ctrl Z |
Undo |
| Ctrl Y |
Redo |
| Alt F4 |
Exit |
| Ctrl X |
Cut |
| Ctrl C |
Copy |
| Ctrl V |
Paste |
| Navigation |
| Ctrl F6 |
Move between Workbooks |
| Ctrl PageDown |
Move to Next Worksheet |
| Ctrl PageUp |
Move to Previous Worksheet |
| Ctrl Home |
Go to First Cell |
| Ctrl End |
Go to Last Cell |
| Worksheet |
| Ctrl A |
Select Whole Worksheet |
| Shift Spacebar |
Select Row |
| Ctrl Spacebar |
Select Column |
| Shift F11 |
Insert New Worksheet |
| Cell |
| F2 |
Edit Cell |
| Ctrl B |
Bold Toggle |
| Ctrl I |
Italic Toggle |
| Ctrl U |
Underline Toggle |
| Ctrl 5 |
Strikethrough Toggle |
| Ctrl Shift F |
Change Font |
| Ctrl Shift P |
Change Font Size |
| Alt Enter |
Wrap Text |
| = |
Insert Formula |
| Ctrl Shift 7 |
Apply Borders |
| Ctrl Shift _ |
Remove Borders |
| Ctrl Shift 4 |
Format As Currency |
| Ctrl Shift 5 |
Format As Percentage |
| Ctrl Shift 1 |
Format As Number |
| Ctrl Shift # |
Remove Formatting |
| Insert Text Automatically |
| Alt = |
Sum a Range of Cells |
| Ctrl ; |
Insert Date |
| Ctrl Shift ; |
Insert Time |
| Ctrl Shift + |
Insert Columns/Rows |
| F11 |
Create Chart for Selected Range |
Filed under: Office / Productivity | Comment (1)
November 29th, 2007

You may preform virus scanning regularly to keep your computer clean from virus. You should also preform regular cleaning on your computer, monitor, keyboard, mouse and other hardwares.
1. Monitor
Use a soften cloth and do not use detergent or other liquid. You are advised to turn the monitor off before cleaning it.
Keep your monitor clear can make your work more effective. It is also important to keep the vents clean to avoid overheating, so remember to remove the dust on the holes at the back of the monitor.
2. Keyboard
Keyboard is easy to trap the dust and dirt. These dust will make your key sticky and not as sensitive as before.
Turn the keyboard upside down and shake to remove dust and dirt. You can also use a soft brush or a can of compressed air to squeeze out the dust. Remember to uplug the keyboard before cleaning.
It is better keep your keyboard covered when you are not using them.
3. Mouse
Take off the cover at the back and the ball out. Clean the ball with a soft cloth. Remove the sticky dust on the two thin wheels. You can also try to shake out dirt that gathers in the hole.
4. Case
Open the case and remove the dust gathered there. Remember to unplug the machine before cleaning and also avoid any physical contacts with the inside components.
Filed under: Office / Productivity | Comment (1)
February 8th, 2007

Sometimes we need to type symbol, but it is troublesome to locate in the symbol table.
You can directly type in the symbol by using your keyboard.
1. While pressing down the ALT key, type the code on the Number Pad (the right edge of keyboard).
2. Release the ALT key. The character will appear when the ALT key is released.
For example, press and Hold “Alt” key and type 41400 in your Number Pad. Release the “Alt” key and you will see a symbol shown out.
Follows is the list of the symbol and its code

Filed under: Office / Productivity | Comment (0)