Microsoft Office Tutorials and References
In Depth Information
Entering the Same Formula in Many Cells
Figure 8.22.
Figure 8.22. Even with a large range selected, the formula is built only in
Even with a large range selected, the formula is built only in
the active cell.
the active cell.
44. At this point, you would normally press Enter to complete the for-
mula. Instead, press Ctrl+Enter to enter this formula in the entire se-
lected range. Note that Excel does not enter =B2*$F$1 in each cell. In-
stead, it converts the formula as if it were copied to each cell. Figure
8.23 shows the formula in cell C10.
Search JabSto ::




Custom Search