Microsoft Office Tutorials and References
In Depth Information
Working with formulas
Excel assumes that labels included in the selection are the names for each range. For
example, Figure 12-14 shows that with A3:E7 selected, the Top Row and Left Column options in
the Create Names From Selection dialog box are automatically selected, creating a set of
names for each quarter and each region. Note that when using Create From Selection, you
need to select the labels as well as the data. When you click the Name Manager button,
you’ll see the names you just created listed in the dialog box.
Selecting cells while a dialog box is open
The Refers To text boxes in the New Name and Name Manager dialog boxes (and many
other text boxes in other dialog boxes) contain a collapse dialog button , located on
the right side of the edit box. These edit boxes, when active, allow you to navigate and
select cells on the worksheet. Most of the time, Excel complains loudly (ding!) when
you click outside a dialog box. For example, after you click the Refers To text box, you
can click outside the dialog box to select any other worksheet tab, drag scroll bars,
switch workbooks, or make another workbook active. In addition, if you click the
collapse dialog button, sure enough, the dialog box collapses, letting you see more of the
worksheet, as shown here:
You can drag the collapsed dialog box around the screen using its title bar. When you
finish, click the collapse dialog button again, and the dialog box returns to its original
Naming constants and formulas
You can create names that are defined by constants and formulas instead of by cell
references. You can use absolute and relative references, numbers, text, formulas, and functions
as name definitions. For example, if you often use the value 8.3% to calculate sales tax,
you can click the Define Name button, type the name Tax in the Name box, and then type
8.3% (or .083 ) in the Refers To text box. Then you can use the name Tax in a formula, such
Search JabSto ::

Custom Search