Word: Create a list of AutoText options
In addition to eliminating keystrokes, Word's AutoText feature can help standardize communication throughout an organization. For example, suppose you want to use a standard set of signatures across the organization. You can insert an AutoTextList field code in a document or template that provides a shortcut menu that lists correct signatures.
First, you must add the appropriate signature entries to the Signature style. In a blank document, type the first signature (e.g., Mary Jones, CPA), and select it. Select Signature from the Style drop-down list in the Formatting toolbar. With the name still selected, press [Alt][F3], and click OK in the Create AutoText dialog box.
Repeat these steps for each name you want to add to the Signature style under AutoText.
To insert the AutoTextList field in a document or template, follow these steps:
For example, your entry might look like this: AutoTextList "Mary Jones, CPA" /s "Signature" /t "Click the right mouse button for a list of valid signatures."
Users can now right-click the default signature to reveal a shortcut menu listing all valid signature options.
Excel: Change default worksheet options
By default, Excel includes three worksheets in a new workbook. But if most of your users rarely use more than one worksheet per workbook, you can prevent Excel from generating the two extra worksheets.
Follow these steps:
The next time you create a new workbook, it will have only one worksheet. You can also increase the number of sheets per workbook.
You can also use the Options dialog box to change the worksheet's default font. For example, to change the default font from Arial 10 to Times New Roman 12, follow these steps:
You must restart Excel for your font changes to take effect.
Access: Prevent users from changing data in forms
In certain forms, such as those based on queries, you may not want users to be able to update some or all of the fields. If so, you can prevent users from updating any field in a form.
Follow these steps:
You can also design a form so that pressing the [Tab] key doesn't stop on a locked field during data entry. Follow these steps: