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

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.