Tech

Guides

Business Applications ▪ Database Management ▪ Disaster Recovery ▪ Enterprise Servers & Storage ▪ IT Security ▪ Java ▪ Microsoft Office Suite ▪ Network Admin ▪ Open Source ▪ SMB ▪ SOA ▪ Tech Management ▪ Software/Web Development ▪ Windows Server ▪ Wireless Tech

Microsoft Office Suite TechGuides

Add your own Quick Parts to Word 2007

By Mary Ann Richardson, Special to ZDNet Asia
Thursday, March 20, 2008 11:17 AM

Word 2007 has replaced the AutoText feature with Quick Parts that lets you create Quick Parts for frequently used document content such as a paragraph, logos, graphics, specifically formatted headers or footers, or standard tables.

Microsoft Word

Add your own Quick Parts to Word 2007 Building Block Organizer

Word 2007’s Quick Parts promise to save you time with one-click formatting. However, if the available building blocks do not match your document needs, you’ll spend more time than you would like reformatting them.

Fortunately, Word lets you add your own custom building blocks so you only have to reformat them once.

For example, suppose you frequently use one of Word 2007's built-in cover sheets--but you need to add your company information each time you do. To add the reformatted cover sheet with your company name to the Building Block gallery, follow these steps:

Select the reformatted cover sheet with your company name.
Press [Alt][F3].
Click in the Name box and enter ABC Report Cover Sheet.
Select Cover Pages in the Gallery box.
Enter (ABC Company) in the Category box. By placing the category name in parentheses, your company's custom building blocks will appear at the top of the Building Block gallery. Then, click OK.

If Word prompts you to save the changes to the normal template before exiting, click Yes. To add the cover sheet Quick Part to the Quick Access Toolbar, right-click the block in the Building Block gallery and select Add Gallery to Quick Access Toolbar.

Now, you can quickly insert the cover page in another document by typing its name ABC Report Cover Sheet and pressing [F3] or by clicking its icon in the Quick Access Toolbar.

Note that Word 2007 has replaced the AutoText feature of previous releases with Quick Parts. Thus, instead of creating AutoText entries, you would create Quick Parts for any frequently used document content such as a paragraph, logos, graphics, specifically formatted headers or footers, or standard tables.

Microsoft Excel

Turn off error checking when entering numbers into Excel text fields

You designed your Excel spreadsheet so that you will be able to keep track of your products' prices and part numbers, and you applied the Text format to the Part Number column--yet every time you enter a part number into a cell, the Smart Tag pops up with a Number Stored As Text error. You can turn off this type of error checking without having to turn off Smart Tags altogether--follow these steps to prevent the error from occurring in Excel 2007:

Click the Office button.
Click the Excel Options button.
Click Formulas in the left column.
Under Error Checking, clear the Numbers Formatted As Text Or Proceeded By An Apostrophe check box.

To prevent the error from occurring in Word 2002/2003:

Go to Tools | Options.
Click the Error Checking tab.
Clear the Number Stored As Text check box, and click OK.

Microsoft Access

Get quick help with your Access forms with ToolTips

When designing an Access application, don't neglect to plan for the ToolTips! ToolTips let you provide context-sensitive help wherever and whenever needed. To access your ToolTip help, simply move your mouse pointer over a control on the form and the Tooltip will appear with help on that control. Not only can ToolTips cut down on training time, they can also reduce the number of calls to the help desk. To add a ToolTip to a form control, follow these steps: