Microsoft Office Tutorials and References
In Depth Information
Working with formulas
Working with formulas
We’ve covered most of the basics you need to know about how formulas and references
work. In the following sections, we’ll dig deeper, covering how to use defined names,
intersections, structured references, and three-dimensional (3-D) formulas.
Naming cells and cell ranges
If you find yourself repeatedly typing cryptic cell addresses, such as Sheet3!A1:AJ51 , into
formulas, here’s a better approach. Assign a short, memorable name to any cell or range
and then use that name instead of the cryptogram in formulas. Naming cells has no effect
on either their displayed values or their underlying values—you are just assigning
nicknames you can use when creating formulas.
Each workbook contains its own set of names. After you define names on any worksheet,
those names become available to every other worksheet in the workbook. You can also
define worksheet-level names that are available only on the worksheet in which they are
defined.
For more information about worksheet-level names, see “Workbook-wide vs. worksheet-only
names” later in this chapter.
Using names in formulas
When you use the name of a cell or a range in a formula, the result is the same as using the
cell or range address. For example, suppose you type the formula =C1+C2 in cell C3. If you
assign the name Roger to cell C1 and the name Terry to cell C2, the formula =Roger+Terry
has the same result and is easier to read.
The easiest way to define a name follows:
Select a cell.
1.
Click the Name box on the left end of the formula bar, as shown in Figure 12-10.
2.
Figure 12-10 Use the Name box on the formula bar to quickly assign names to cells and
ranges.
Search JabSto ::




Custom Search