Microsoft Office Tutorials and References

In Depth Information

**Using F4 on a Rectangular Range**

However, you can still use F4 by clicking somewhere in the formula bar ad-

jacent to the characters A6. Pressing F4 now adds dollar signs to that ref-

erence.

Using F4 on a Rectangular Range

Some functions allow you to specify a rectangular range. For example, in

Figure 8.16
,
you would like to enter a formula to calculate month-to-date

sales. Although =SUM(B2:B29) works for cell C29, you cannot copy this

formula to the other cells in the column. To copy this formula, you need to

change the formula to =SUM(B$2:B29).