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.