Microsoft Office Tutorials and References
In Depth Information
Working with Database Functions
To set up a name, follow these steps:
1. Select the entire database area.
Make sure the top row has headers and is included in the selection.
2.ClicktheFormulastab(atthetopoftheExcelwindow).
3. Click Define Name in the Defined Names area.
The New Name dialog box appears, with the range address set in the
Refers To box.
4.TypeanameintheNameBox(orusethesuggestedname).
5.ClickOKtoclosethedialogbox.
Later, if records are added to the bottom of the database, you have to redefine
the named area’s range to include the new rows. You can do this as follows:
1.ClicktheNameManagerbuttonontheExcelFormulastab.
The Name Manager dialog box appears.
2. Click the name in the list you want to redefine.
3.ClicktheEditbuttoninthedialogbox.
Excel opens the Edit Name dialog box, shown in Figure 17-2, with
information about the selected range.
Figure 17-2:
Updating
the
reference to a
named area.
4.ChangethereferenceintheRefersTobox.
You can use the small square button to the right of the Refers To box to
define the new reference by dragging the mouse pointer over it. Clicking
the small square button reduces the size of the Edit Name dialog box
and allows you access to the worksheet. When you are done dragging
the mouse over the new worksheet area, press Enter to get back to the
Define Name dialog box.
Search JabSto ::




Custom Search