Microsoft Office Tutorials and References
In Depth Information
EX 136
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
To Display the Formulas in the Worksheet and Fit the Printout on One Page
The following steps change the view of the worksheet from the values version to the formulas version of the
worksheet and then print the formulas version on one page.
1
Press CTRL + ACCENT
MARK (`).
numbers displayed
using General format
When Excel displays
the formulas version
of the worksheet,
click the right
horizontal scroll
arrow until column J
appears to display
the worksheet with
formulas
(Figure 2–74).
formulas displayed
as entered
2
If necessary, click
the Page Layout tab
on the Ribbon and
then click the Page Setup Dialog Box Launcher to display the Page Setup dialog box.
Figure 2–74
If necessary, click Landscape to select it and then click Fit to in the Scaling area.
3
Click the Print button in the Page Setup dialog box to print the formulas in the worksheet on
one page in landscape orientation (Figure 2–75).
When Excel displays the Print dialog box, click the OK button.
font size automatically
reduced so worksheet
fi ts on one page
formulas instead
of values printed
Figure 2–75
4
After viewing and printing the formulas version, press CTRL + ACCENT MARK (`) to instruct Excel to display the values version.
Click the left horizontal scroll arrow until column A appears.
Other Ways
1. Click Show Formulas
button on Formulas tab
on Ribbon
C6161_EXC_02.4c.indd 136
C6161_EXC_02.4c.indd 136
3/6/07 3:29:52 PM
3/6/07 3:29:52 PM
 
Search JabSto ::




Custom Search