Microsoft Office Tutorials and References

In Depth Information

You can use a similar technique when you add a formula to an Excel table column. If the

sale price and rate data were in an Excel table and you created the formula
=B4*C4
in

cell D4, Excel would apply the formula to every other cell in the column. Because you

used relative references in the formula, the formulas would change to reflect each cellâ€™s

distance from the original cell.