Concepts


Where do I put the "absolute" values?

There are no rules about this. You can arrange your spreadsheet any way you like. However, it is generally useful to keep your reference values near the upper or left edges of the spreadsheet.

The reason for this is simply that the raw-values and computed-values sections of your spreadsheet may grow quite large as you build it. The reference values, on the other hand, tend to be small in number and stay that way.

If your reference values are contained within the upper left corner, you can freely expand the more dynamic portions of your spreadsheet, and add and delete columns and rows, without pushing your reference values farther and farther outward. You'll always know where to find them.


Copyright 1997 by the Curators of the University of Missouri