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.