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-
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).
Search JabSto ::

Custom Search