Friday, 27 November 2009

Save changes to all open Word documents at one time

If you’re working in multiple documents in Word 2003 and want to make sure you’ve saved your changes to all of them, all you have to do is press the [Shift] key and pull down the File menu. Word will add the Save All command to the menu, above the Save As command. Word will prompt you to save each document that has any unsaved changes.

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.