Microsoft Office Tutorials and References
In Depth Information
Using F4 After a Formula Is Entered
66. Press Enter to accept the formula.
77. When you copy the formula from cell C6 to the range C6:G28, the for-
mula automatically multiplies the rate in column A by the number of
days in row 5. Figure 8.15 shows the copied formula in cell E9. The
formula correctly multiplies the 10-dollar rate in cell A9 by the 24
hours figure in cell E5.
Figure 8.15.
Figure 8.15. By using the correct combination of row and column mixed refer-
By using the correct combination of row and column mixed refer-
ences, you can enter this formula once and successfully copy it to the en-
ences, you can enter this formula once and successfully copy it to the en-
tire rectangular range.
tire rectangular range.
Using F4 After a Formula Is Entered
The F4 trick described in the preceding section works immediately after you
enter a reference. If you try to change cell A6 after you type the asterisk,
pressing the F4 key has no effect.
Note
After you press F4 again, Excel returns the reference to the relative
state A6. As you continue to press F4, Excel toggles between the four
modes. It is fine to toggle between them all and then choose the correct
one. If you accidentally toggle past the $A6 version, just keep press-
ing F4 until the correct mode comes up again.
Search JabSto ::




Custom Search