Word Tips
Find Your Place In Word Documents
Add Attractive Lines In Word
Select A Column In a Word Table
Prevent Printing Separate Page

Excel Tips
Format Excel Cells Fast
Have Excel Save Files Automatically
Build Vertical Titles In Excel

PowerPoint Tips
Take A Break During Slide Show
Restoring The Size Of A Picture
Fitting Text Inside An Object
Multiple Objects

Access Tips
Upper Case Letters
Navigating
Zoom In On A Field

Home

Outlook Tips
Add Contacts Quickly In Outlook
Send An Office Document Without Opening Outlook

Contact Details
E-mail Enquiries
Data-Flow Website
Phone: 01656 648028
Mobile: 0802 167466

MICROSOFT WORD TIPS

Find Your Place in Word Documents

If you are working on a long document, it's easy to lose your place. With Microsoft Word documents, you can pick up where you left off in your last editing session because Word keeps track of the last three locations where you typed or edited text. Just press SHIFT+F5 immediately after opening the document, and the cursor will appear at the exact point where you last made a change. To reach the previous two editing locations, press SHIFT+F5 until you reach the location you want.

Add Attractive Horizontal Lines in Word

It's easy to add a variety of horizontal divider lines to Word documents. To create a solid, black line for example, type three HYPHENS (-) at the beginning of a new paragraph and then press ENTER. Typing three UNDERSCORES (_) will make a thicker line, and so on.
Try these…..
--- (Three HYPHENS)
___ (Three UNDERSCORES)
=== (Three EQUAL SIGNS)
###(Three HASH SIGNS)
*** (Three ASTERISKS)
~~~ (Three TILDES)

To select an entire column in a table

1. Point the mouse pointer anywhere inside the column to select.
2. Hold down the [Alt] key and click the Left Mouse Button.
3. Hold down the mouse button and drag to select multiple columns

To prevent Word from printing two or three lines on a separate page

1. Click on the Print Preview icon on the Standard Toolbar.
2. Click on the Shrink to Fit icon.
3. Click on the Print icon.

MICROSOFT EXCEL TIPS

Format Excel Cells Fast

If you want quick access to the Format Cells dialog box in Microsoft Excel to change things like type style, alignment, or borders, select the cell you want to format and press CTRL+1.

Have Excel Save Your Files Automatically

Have you ever wanted Excel to automatically save your spreadsheets for you so you don't lose your work? Excel includes a feature that saves workbooks automatically at specified intervals, but it's not installed by default. Here's how you can install and use the Autosave Add-in:

1. First you need to load the add-in, which will add it to your Tools menu:
2. On the Tools menu, click Add-Ins.
3. In the Add-Ins available list, select the Autosave Add-in check box and then click OK. ( Note: If the Autosave Add-in is not available, you may need to install it. For more instructions, search for the phrase "Install or remove individual features of Microsoft Office or Excel" in Excel 97/2000 Help.)

Then, to configure and use the Autosave feature:
1. On the Tools menu, click AutoSave.
2. Select the Automatic save every check box.
3. In the Minutes box, enter how often you want Excel to save your workbooks.
4. Select any other options you want, and press OK.

Build Vertical Titles in Excel

Have you ever wondered how to create a heading for a table that runs vertically along the side of a table instead of above it?
Here's how I do it:
1. Select the cell that contains your text as well as the surrounding cells that you want your title to span.
2. On the Format menu, click Cells, and then click the Alignment tab.
3. In the degrees text box, enter 90.
4. Select the Merge cells text box and click OK.

MICROSOFT POWERPOINT TIPS

Take a Break During a PowerPoint Slide Show

Here's an easy yet very useful tip for those who give presentations using PowerPoint slide shows. When you want to stop for a break in your presentation without losing your place in the slide show, just press the lowercase B key or press the FULLSTOP (.). This will make the screen go black, and if it is a self-running presentation, it will pause. When you are ready to resume the show, press either key again, and you will start right where you left off.

Restoring the Size of a Picture

If you distort an picture as you resize it, you can restore it to the original size:

1. Place the mouse pointer on any resize handle.
2. Hold down the [Ctrl] key.
3. Double-click the Left Mouse Button.

Fitting Text inside an Object

If text is too big to fit inside an object, you can either resize the object and/or wrap text inside the object.

1. Click on the object with text to select it.
2. Click on the Format, AutoShape Menus.
3. Click on the Text Box Tab.
4. Click on Resize AutoShape to Fit Text and/or Click on Word Wrap Text In Autoshape.
5. Click OK.

Multiple Objects

If you have multiple objects on a slide, press the [Tab] key to select one object at a time.

MICROSOFT ACCESS TIPS

Upper Case Letters

When typing text into a table, Access will automatically uppercase characters for you. (This is convenient when typing middle initials, state names, department names, etc.)

1. Open the table in the Design View.
2. Click on the appropriate field in the top part of the window.
3. Click in the Format box in the Properties window and type a ">" (greater-than sign).
4. Switch to the Table View, saving the Design View.
5. Type the appropriate data in lowercase letters.
6. Press [Enter]. Text will automatically change to uppercase.

Navigating

When navigating in Access: [F2] Switches between the Navigation Mode and the Edit Mode. (This works in a table, query or form.)

To copy the contents of a field/cell from the previous record simply hold the Ctrl key down and press the apostrophe key ('). This works in Excel as well as Access.

Zoom In On A Field

1. Click the Left Mouse Button on the field in the QBE Grid.
2. Press [Shift] + F2.

MICROSOFT OUTLOOK TIPS

Add Contacts Quickly In Outlook

If you receive an e-mail message from a person whom you want to add to your Outlook contact list, here's a quick way to do it:

Open the e-mail message that contains the name you want to add to your contact list. In the From box, right-click the name you want to make into a contact, and then click Add to Contacts on the Shortcut menu. This creates a new contact with that person's name and e-mail address already filled in. You can also fill in any additional information you have about that person, such as a phone or fax number, and then save it in your Contacts folder for easy access.

Send An Office Document Without Opening Outlook

Ever need to get that important Word document to your boss in a hurry? Here's how you can do it without even opening Outlook.

1. On the File menu, point to Send To, and then click Mail Recipient (as Attachment).
2. Fill in the Receipts, Subject, and message boxes and click Send.

Or if you have Word 2000:

1. On the Standard toolbar, click E-mail.
2. In the To and Cc boxes, enter the recipient names separated by semicolons.
3. By default, the name of the document appears in the Subject box. If you want, you can type your own subject name.
4. Click Send a Copy.