Archive for August, 2005

Selecting Text Vertically with ALT-drag!

August 29th, 2005

First, you are probably asking yourself, “What does he mean by selecting text vertically?’
Answer: Selecting text vertically allows you to select the first character in every line of a document (or the first two characters, three, etc.) See the example below.
Now that you know what selecting text vertically is, you are probably asking […]

Password Protect Your Outlook Data File

August 29th, 2005

To add a password to Outlook 2003:

Open Outlook.
Select File | Data File Management.
Select Personal Folders from the Name column.
Click the Settings button.
Click Change Password…
The following dialog box will appear:

If you don’t have an old password, leave that field blank.
Type the password you want in New Password.
Type it again […]

Packaging Your Presentation to CD

August 29th, 2005

When you have to create a PowerPoint presentation on one computer and show it on another, you face a number of potential problems. Are the fonts you used installed? Did you copy all the graphics and charts you needed? Does the new computer have PowerPoint and is it the right version? Microsoft has addressed […]

Moving and Selecting Cells in Excel

August 29th, 2005

Moving to different cells using the mouse is all well and good, but what happens when you have a list with 5,000 odd rows? Moving to the end of the list or, worse, highlighting to the end of the list is cumbersome with the mouse. (See the end of this tip for an exception.)
The […]

Displaying Zipcodes in a Word Mailmerge

August 29th, 2005

Excel provides a Special number format for zipcodes which allows those of us in New England to display our zipcodes properly. However, when you do a mail merge in Word 2002 and 2003, this formatting will not come through. A zipcode of 01040 will display as 1040. You can fix this in Excel by converting […]