Microsoft Office Tutorials and References
In Depth Information
Entering the Same Formula in Many Cells
22. Click in the first cell and drag down to the last cell, as shown in
Figure 8.21 . Notice from the name box that the active cell is the first
cell.
Figure 8.21.
Figure 8.21. Click in the first cell and drag down to the last cell to select a
Click in the first cell and drag down to the last cell to select a
range with the first cell as the active cell.
range with the first cell as the active cell.
33. Enter the formula by using any of the three methods described earlier
in this chapter. Even if you use the arrow key method, Excel keeps the
entire range selected. Figure 8.22 shows a formula after you press F4
to convert the F1 reference to $F$1.
Search JabSto ::




Custom Search