Adding Comments and Equation Notes
Problem
You'd like to add comments to your spreadsheet, just as you'd comment your code in a traditional programming language.
Solution
Aside from simply inserting text in cells adjacent to cells containing data or formulas, you can use comments or equation objects to document your spreadsheets.
Discussion
Figure 1-23 shows a sample spreadsheet that includes a comment and an equation object documenting parts of the spreadsheet.
Figure 1-23. Spreadsheet with comment and equation
The comment is the rectangle containing the text "David Bourg: This is the exponent," with an arrow pointing to cell D2. The equation object is the rectangle containing the mathematical expression for the area calculation. Both comments and equations are useful devices for documenting your spreadsheets. I often use comments to leave myself notes or reminders or to-do lists within my spreadsheets. I use equations to document formulas used in my spreadsheets that will be used by others or included in reports or other presentations. Equations in standard mathematical form are much clearer and far easier to comprehend than cell formulas containing a bunch of cell references and operators all strung together.
To add a comment, first select the cell to which you want the comment attached, then select Insert
|
To add an equation, you need to use the Microsoft Equation Editor to insert an equation object into your spreadsheet. Select Insert
The equation rectangle will appear, allowing you to enter an equation using the equation toolbar shown in Figure 1-24. You can type text in the equation using the keyboard. To insert mathematical symbols, select them from the equation toolbar. Use the arrow keys on the keyboard to navigate an equation while editing. The Equation Editor is a bit cumbersome at first; I suggest you try it and practice until you get the hang of it. When you're done entering an equation, simply click anywhere in your spreadsheet to close the Equation Editor. You can click and drag the resulting equation to place it anywhere in your spreadsheet. To edit an existing equation, select it and then right-click on it to reveal a pop-up menu. Select Equation Object
Figure 1-24. Editing an equation
See Also
There's an alternative to editing equations directly on your spreadsheet as illustrated in Figure 1-24. If you select an equation object and then right-click to open the pop-up menu, you can select the Equation Object
The Equation Editor also contains a help menu option. Select Help
|