King Web Design and Computer Services Pty Ltd
Friday, 27 November 2009
Wednesday, 18 November 2009
Two quick ways to sum Excel data
There are two easier ways to sum values:Highlight the row or column, plus one blank cell for the result
* press [Alt]++ OR
* click AutoSum on the Standard toolbar.
For example, if you want to sum the values in cells B2:B5, you selecte cells B2:B6, and then press [Alt]++ or click AutoSum. Excel will display the sum in cell B6. You don’t have to enter a thing — just highlight and click or press.
Obviously, AutoSum is the easiest route, but the Standard toolbar isn’t always available, so knowing the [Alt]++ combination might come in handy. Most methods work with multiple columns and rows and noncontiguous blocks of values.
Friday, 13 November 2009
Creating AutoComplete Entries in Word
AutoComplete anticipates what you are typing and offers to complete it. To setup an AutoComplete entry:1. Select the text
2. Select the Tool menu, then choose AutoCorrect Options
3. Select the AutoText tab
4. Activate by ticking (if not already done so) the
"Show AutoComplete suggestions" option
5. Click the Add button.
6. Click the OK button.
Hope this helps.
Thursday, 5 November 2009
Changing the MS Outlook Mail alert options
There are a number of emails alerts options in MS Outlook which can be turned off.Here is the procedure
1. From the Tools menu, select Options
2. From the Preference tab, select the Email Option button
3. Select the Advance Email Option button
4. Select the required alerts or unselect by removing the tick from the box
5. Select the OK button three times.
Hope this helps.

