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.
 
Search JabSto ::




Custom Search