Tech Tip: Word toolbar buttons/Create an Excel template/Change Access text box label position

Word: Add a button to a toolbar

You can't access all of Word's built-in buttons from the default toolbars. To use some built-in buttons, you'll have to add them to a toolbar.

For example, suppose you regularly use the Tools menu to check a document's word count, but you'd rather use a button. Follow these steps to add the Word Count button to the Formatting toolbar:

  1. Right-click the Formatting toolbar, and select Customize.
  2. On the Commands tab, select Tools from the Categories box.
  3. Drag Word Count from the Commands box to the Formatting toolbar.

To apply this change to all documents, click Close. To apply this change only to the current document, select the name of the document in the Save In box, and click Close.

If the change is saved in Normal, then the changed toolbar becomes the default. If you save the change in the current document, the change will appear only when that document is opened.

To delete a button from a toolbar, press [Alt] while clicking and dragging the button off the toolbar.

Excel: Create a template

As with Word, you can create a template in Excel for frequently used worksheets. For example, suppose that you create a new worksheet each month to record the total number of volunteer hours worked in your organization. Rather than re-create the worksheet, you can delete the text and numbers entered for the month and save the format and formulas to a template.

Follow these steps:

  1. Go to File | Save As.
  2. In the Save As Type text box, select Template from the drop-down list.
  3. Enter your template's name in the File Name box, and click Save.

Excel saves the template to the Templates folder with an .xlt file extension. To use the template, go to File | New and double-click the template's icon.

To make changes to your template, go to File | Open and select the Templates folder from the Look In drop-down list. Select and open your template, make your changes, and click Save. The next time you access your template from File | New, the document will include the updates you made to the template.

Access: Change the default positions for attached text box labels

Every time you create a text box, Access attaches a label to the left of it by default. While you can click and drag the label to reposition it, if you need to reposition a number of controls, it's quicker to change the default.

To change the default so the label appears at the right of the text box, follow these steps:

  1. Open the form in Design view, and click the Formatting toolbar's Toolbox button.
  2. Double-click the form's Properties button (the box in the upper-left corner where the rulers meet) to open the form's Properties window.
  3. In the Toolbox, click the Text Box button, and the Properties window will display the default Text Box properties.
  4. On the Format tab, change the default from -1 to 1 for the Label X property.
  5. Click in the form to create the text box with a label attached to the right.

You can also change the default position of the attached label so it's located above the text box. Follow the above procedure, but set the Label X property to 0 and the Label Y property to -.25 in Step 4. This changes the default position of the label to one-quarter inch above the text box.

Editor's Picks