Projectwoman - means nothing but tutorials..

Better looking publications in Word
When you’re preparing newsletters, company reports and other formal documents in Word you will find that they’ll look more professional if you condense your fonts slightly. Even a reduction as small as .3 points changes the look of the font significantly.

To do this, select the text to alter and choose Format, Font, Character Spacing tab and set the Spacing to Condensed and the By value to, say, .3 points. Print a paragraph at various values to find a value that is pleasing to your eye.

You can create a toolbar button to make it easier to set this condensed value in future. Right click any toolbar and choose Customize then select the Commands tab and, from the Categories list choose All Commands. Scroll to locate the Condensed: item and click it.

At the foot of the dialog a box appears from which you can select a point size to adjust to, for example, choose 0.3 pt and then drag the Condensed option onto the toolbar and close the Customize dialog. In future to condense your type, select it and click your toolbar button.

Helen Bradley

Color code your Outlook 2003 appointments
Make the appointments in your calendar stand out by color coding them. For example, show personal appointments as one color, meetings as another and blocked out time in the office as another.

To do this, click the Calendar and select the Calendar Coloring button on the Standard toolbar.

Choose Edit Labels and, opposite each color make sure the descriptions for the types of appointments you want to use are entered.

To color code an appointment click the Label drop-down menu and choose the color to use.

Helen Bradley

Finding messages in Outlook
When you repeatedly perform a search to find messages matching a particular criteria, create a Search Folder so matching messages will be stored and updated permanently.

To do this, in Outlook 2003, locate the Search Folder entry in the folders list, right click and choose New Search Folder.

Configure the criteria such as mail from someone or including some particular word and click Ok.

At any time, open the folder to read matching messages.

Helen Bradley

This Excel 2003 macro formats a cell depending on its contents when you type something in it. If you type a number, or a formula that returns a number, it is formatted one way, if you type a date it is formatted another way and if you type a word it is formatted a different way.

The macro uses the OnEntry event which fires whenever something is entered into a cell. Attach the macro to an Auto_Open macro to ensure it is run whenever the workbook is opened.

To create this, choose Tools, Macro, Visual Basic Editor and, choose Insert, Module to add a module to the current worksheet then type the code into it.

Back in Excel choose Tools, Macro, Auto_open to run the macro the first time to test it. Provided you have Excel configured to run macros, it will run automatically every time you open the workbook in future.

Sub Auto_Open()
ActiveSheet.OnEntry = “formatCell”
End Sub

Sub formatCell()
If IsNumeric(ActiveCell) Then
ActiveCell.Font.Name = “Verdana”
ActiveCell.Font.Size = 12
ActiveCell.Font.ColorIndex = 46
ElseIf IsDate(ActiveCell) Then
ActiveCell.Font.Name = “Verdana”
ActiveCell.Font.Size = 10
ActiveCell.Font.ColorIndex = 50
Else
ActiveCell.Font.Name = “Times New Roman”
ActiveCell.Font.Size = 12
ActiveCell.Font.ColorIndex = 5
End If
End Sub

Sub Auto_Close()
ActiveSheet.OnEntry = “”
End Sub

Helen Bradley

It is possible to use Word’s search and replace option to add text to the search text.

To do this, choose Edit, Replace and, in the Find What box type the text to locate. In the Replace with box type the text to add to the text you’re searching for and use ^& to refer to the search text.

For example, to replace Sydney with Sydney, NSW search for Sydney and replace with ^&, NSW.

Helen Bradley