Microsoft Office Tutorials and References
In Depth Information
Speed Techniques for Entering Formulas
Figure 3-5:
Clicking to
enter a cell
reference.
Entering a cell range
A cell range is a line or block of cells in a worksheet. Instead of typing cell
reference addresses one at a time, you can simply select cells on your
worksheet. In Figure 3-6, I selected cells C3, D3, E3, and F3 to form cell range
C3:F3. This spares me the trouble of entering one at a time the cell addresses
that I want in the range. The formula in Figure 3-6 uses the SUM function
to total the numeric values in cell range C3:F3. Notice the marquee lights
around the range C3:F3. The lights show precisely which range you’re
selecting. Cell ranges come in especially handy where functions are concerned
(see “Working with Functions,” later in this chapter).
Figure 3-6:
Using a cell
range in a
formula.
Search JabSto ::




Custom Search