Evinco Knowledge Sharing Column Blog

Posts tagged ‘keyboard’

Keyboard Shortcuts for Excel



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

Clean Up your Computer



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.

Type Symbol Quickly



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