Microsoft Office Tutorials and References

In Depth Information

**Handling Special Printing Needs**

3.
Click the Comments arrow and specify how

you want your comment printed from the

drop-down list (see Figure 10-9).

4.
Click OK to close the dialog box.

5.
Print your worksheet as usual.

Figure 10-10

Showing formulas in Excel.

After Excel displays the formulas on the

worksheet, you can print the worksheet as usual. Click

the Show Formulas button again to hide the

formulas and return the worksheet to normal.

Figure 10-9

The Comments option on the Sheet tab.

Adjusting Cells for

Large Formulas

In most cases, you will need to adjust the cell

widths to accommodate the wider formulas.

Showing Off Your Formulas

Formulas are equations that perform calculations

on the contents of Excel’s data cells. Formulas are

extremely useful, as you discovered in Chapter 2,

“Working with Formulas.” So useful, in fact, that

there is sure to come a time when you will want

to see exactly what formulas you used in the

worksheet.

Printing Named Ranges

As you learned in Chapter 1, “Creating a Basic

Excel Worksheet,” named ranges can be used to

quickly find frequently used data. This data can

be in adjacent cells or in non-adjacent cells. In

both cases, set the print area using the named

range as described in these steps.

To show the formulas you used in your

worksheet, choose Formulas > Formula Auditing >

Show Formulas. Excel displays the contents of

each cell as they were entered in the Formula

Bar. As illustrated in Figure 10-10, dates are

converted to the internal code that Excel uses

to perform calculations on them.

1.

Select the named range. Click the down

arrow in the Name box of the worksheet

and select your desired name from the list

(see Figure 10-11). Excel highlights the cells

selected by the named range.