CVibes.net

Home | Links ( Motorcycles, Computers )

Microsoft Office Tips

All of the information, instructions, and recommendations on this Web site are offered on a strictly "as is" basis. Remember "Murphy's Law." Please take the proper precautions before attempting any of the tips or modifications listed here.

Contents

• Double Sided Printing on a single sided printer using Publisher 2002
• Turn Off Startup Task Pane in Microsoft Word
• Change The Location of Where Microsoft Outlook Delivers E-mail
• Fix for: Cannot Change Suggested AutoComplete Date Year Format
• Upgrading From Office 97 to Office 2000 without the Office 97 CD
• Cannot insert an MS Organizational Chart 2.0 object into PowerPoint 2000 under Windows 2000 or XP
• Add a Folder Shortcut to the Open Dialog Box in Microsoft Word 2003
• Add a Folder Shortcut to the Open Dialog Box in Microsoft Word 2007
• How to Generate Sample Text in Microsoft Word
  
• Move Outlook 2003 Data File to a New Location (pdf)
• Microsoft Access Tips
• Links: Microsoft Office
• Computer Tips Index

How to Print Double Sided on a Single Sided Printer Using Publisher 2002

These are the steps I used to print to a HP LaserJet 6P

Create new document using "by publication type" > Programs.

This creates a publication that prints four pages on 8.5" x 11" paper in landscape orientation, 2 pages per side. When folded in half, page 1 is the front, page 4 is the back and pages 2 and 3 are on the inside.

To Print:

1. Go to page 1 of the publication.
2. File > Print > Current Page
3. Answer No to Print as separate booklet? (prints pages 1 and 4)
4. Put page, face down, into the manual feed tray
5. Go to page 2 of publication
6. File > Print > Current Page
7. Answer No to Print as separate booklet? (prints pages 2 and 3)

Turn Off Startup Task Pane

To turn off the Startup Task Pane, go to

1. Tools > Options > View tab
2. Uncheck, Startup Task Pane, within the Show section
3. Click OK

Issue:
Sometimes, even after turning off the Startup Task Pane, the next time Microsoft Word 2003 is started, the Task Pane could come back.

If you are unable to get Word to leave the Startup Task Pane turned off, then you could try the following:

1. Launch Regedit from the Start menu's Run dialog
2. Browse to the key HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\General.
3. Look for a DWORD called DoNotDismissFileNewTaskPane.
4. Double-click it and change its value to 0.

Now the task pane will not automatically open when you start Word.

For those running Office 2002/XP, the fix is exactly the same, but with 10.0 replacing 11.0 in the Registry key.

Change The Location of Where Microsoft Outlook Delivers E-mail

You can choose "Personal Folders" or the e-mail Server

1. Go to: Tools > e-mail Accounts > View or Change existing e-mail accounts
2. Change the option for "Deliver new e-mail to the following location:"

If your e-mail is now being saved in a local file and you want Outlook to leave new e-mail on the mail server instead, then change "Deliver new e-mail to the following location:" from "Personal Folders" to your Exchange Server Mailbox or POP3 account.

Cannot Change Suggested AutoComplete Date Year Format

The AutoComplete feature in Microsoft Word suggests a two-digit year instead of a four-digit year, regardless of how your Regional Settings are configured.

Issue

• Typing today’s date using the text of the month, inserts a 4-digit year as expected.
• Typing today’s date using numbers, inserts a 2-digit year.
• I’ve had this issue with Word 2000, Word XP, and Word 2003.

Workaround
Create an AutoCorrect Entry to correct the date after accepting the suggested AutoComplete date. To do this, follow these steps:

1. On the Tools menu, click AutoCorrect.
2. On the AutoCorrect tab, type /05 in the Replace box.
3. Then type /2005 in the With box.
4. Click Add to add your new AutoCorrect entry to the AutoCorrect list.
5. Click OK to close the AutoCorrect dialog box.

When you type the first four characters of the date, Word suggests today's date as usual. If you type 1/1/, Word suggests the date 1/1/05. Press ENTER, SPACE, or the TAB key to accept the suggested date. When you press the SPACEBAR to type additional text or press ENTER to go to the next paragraph, Word corrects the date with the AutoCorrect entry you added.

For example, Word corrects the date from the date you accepted, 1/1/05, to 1/1/2005.

Upgrading From Office 97 to Office 2000 without the Office 97 CD

Usually when upgrading a large application like Microsoft Office, I prefer to uninstall the old version first. Unfortuntely, Microsoft Office 97 will not let you uninstall it without inserting the Office 97 CD-ROM into the computer. When you use Add/Remove Programs in Control Panel to uninstall Microsoft Office 97, it runs the setup program which then prompts you to:

When I ran into this issue, I didn't have an Office 97 CD with me.

This is not a problem. The upgrade option of Microsoft Office 2000 Professional will delete the current version, Office 97, before installing.

Run setup from your Office 2000 CD and then choose the upgrade option when prompted.

Cannot insert an MS Organizational Chart 2.0 object into PowerPoint 2000 under Windows 2000 or XP

When logged in as a member of the Users group, under Windows 2000 Professional or Windows XP, you may receive an error message that indicates that Microsoft PowerPoint 2000 cannot load the MS organization chart. (See: HOW TO: Create a Custom Default User Profile)

Cause

When MS Organization Chart 2.0 starts it deletes MSOClip.232 from the C:\WINNT\ directory. It then tries to create MSOClip.232, but cannot because the Users group does not have enough rights to create the file in the C:\WINNT\ directory.

Workaround

1. Log in as a user that's a member of the Administrators group
2. Run Microsoft PowerPoint 2000
3. Insert > Object… > MS Organization Chart 2.0. This will create MSOPrefs.232 and MSOClips.232 in the C:\WINNT\ directory.
4. Exit from PowerPoint 2000. No need to save the file.
5. Use Windows Explorer to select both MSOPrefs.232 and MSOClips.232 in C:\WINNT\.
6. Right click on MSOPrefs.232 and MSOClips.232 and choose Properties
7. Select the Security tab, then select the Users group
8. Uncheck "Allow inheritable permissions from parent to propagate to this object," and click on the Copy button from the resulting "Security" window that pops up.
9. "Allow" only Read, Write rights for the files. This should prevent MS Organization Chart 2.0 from deleting MSOClips.232 when it starts. Do not allow "Modify" rights. The "Modify" attribute is the same as the "Delete" attribute in advanced security settings.
10. Click OK to exit the properties and save the settings.

Add a Folder Shortcut to the Open Dialog box in Microsoft Word 2003

1. Open Microsoft Word
2. Click on File > Open
3. Using "Look in:," navigate to the directory you want to add a shortcut to
4. In the Tools menu, click on Add to "My Places"

The Folder Shortcut will be available for the Open and Save dialogs for all Microsoft Office applications.

Add a Folder Shortcut to the Open Dialog Box in Microsoft Word 2007

1. Open Microsoft Word
2. Click the Office Button > Open
3. Using "Look in:," navigate to the directory you want to create a shortcut to
4. Right click in an empty area in the box below "Look in," then choose Add '<Folder name>'

The Folder Shortcut will be available for the Open and Save dialogs for all Microsoft Office applications.

How to Generate Sample Text in Microsoft Word

Microsoft Word 2003

To automatically generate sample text in Word 2003, type =rand() then press the enter key.

You can also use =rand(x,y), where x is the number of paragraphs and y is the number of words in each paragraph.

Microsoft Word 2007

To automatically generate sample text in Word 2007, type =rand() or =rand.old() or =lorem() then press the enter key.

You can also use =lorem(x,y) or =rand(x,y)

Where x is the number of paragraphs and y is the number of words in each paragraph.

Sample Text Function Not Working?

If the =lorem() or =rand() functions do not work in Microsoft Word 2007, make sure that "Replace text as you type" option is turned on.

1. Click the Office Start Button (top-left corner)
2. Click the Word Options button
3. Click the Proofing option (in the left pane)
4. Click the AutoCorrect Options button
5. On the AutoCorrect tab, make sure the "Replace As You Type" check-box is ticked.

When this option is disabled, the =rand() and =lorem() functions are disabled as well.

References:

• How to insert sample text into a document in Word