Software

Tech Tip: Add a border to a Word title page/Use Excel 2002's Go To Special feature/Add concatenated text fields to queries

Find out how to add a border to only part of a document, make Excel find cells for you, and create a calculated field that concatenates two or more text fields.

Add a border to a title page

Word's Borders And Shading feature allows you to control exactly where to place a border in a document. For example, let's say you want only your title page to have a border along the left and right margins.

Follow these steps:

  1. Select the title page, and go to Format | Borders And Shading.
  2. On the Page Border tab, choose a setting.
  3. Decide on your formatting by making selections from the Line Style, Art, Width, and Color drop-down lists.
  4. In the Preview section, click the buttons to turn off the border at the top and bottom margins.
  5. Select This Section - First Page Only from the Apply To drop-down list, and click the Options button.
  6. Select Text from the Measure From drop-down list.
  7. Deselect the Surround Header and Surround Footer check boxes to prevent the border from printing in the header and footer areas, and click OK to exit both dialog boxes.

You can also add a border to a page in the middle of the document by making that page a new section and selecting This Section from the Apply To drop-down list.

Take advantage of Excel 2002's Go To Special feature

In Excel 2000, if you ever wanted to find out if you have any blank cells in your worksheet, or if you wanted to move to the last cell in a 200-row worksheet, you probably had to scroll a lot. But with Word 2002's Go To Special feature, you can now make Excel find the cells for you.

Follow these steps:

  1. Go to Edit | Go To.
  2. Click the Special button.
  3. To find all cells that are blank, select Blanks, and click OK.
  4. To find the last cell in the worksheet, select Last Cell, and click OK.

You can also use this feature to find any cells that contain formulas. If Excel finds more than one cell, it will select all of them.

If you want to know which cells a formula references, select the formula cell, and select Precedents in the Go To Special dialog box. Excel will select every cell referenced by the formula.

Add concatenated text fields to queries

Calculated fields aren't limited to Number and Currency fields. You can also create a calculated field that concatenates two or more text fields.

For example, let's say you want to create a field that combines the Title_of_Courtesy, FirstName, and LastName fields in your Customers table.

Follow these steps:

  1. Create a query based on the Customers table.
  2. In an empty Field cell, enter the following expression:
    [Title_of_Courtesy] & " " & [FirstName] & " " & [LastName]
  3. Press [Tab].
  4. Go back to the Field cell, select Expr1 (without the colon), and enter Mailing Address Name to name the new field.
  5. Add the rest of the address fields to the design grid.

You can now import the results of this query into your labels program.

Editor's Picks