Microsoft Office Tutorials and References
In Depth Information
Displaying and Printing the Formulas Version of the Worksheet
Click the Print button (Page Setup dialog box) to print the formulas in the worksheet on
one page in landscape orientation (Figure 2 – 72). If necessary, in the Backstage view, select
the Print Active Sheets option in the Settings area of the Print gallery.
When Excel displays the Backstage view, click the Print button to print the worksheet.
of values printed
font size automatically
reduced so that worksheet
i ts on one page
Figure 2 – 72
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.
To Change the Print Scaling Option Back to 100%
The Microsoft Ofi ce
program provides an
opportunity for you
to obtain a valuable
industry credential —
proof that you have the
Excel 2010 skills required
by employers. For more
information, visit the
Excel 2010 Certii cation
Web page (scsite.com/
Depending on your printer, you may have to change the Print Scaling option back
to 100% after using the Fit to option. Doing so will cause the worksheet to print at the
default print scaling of 100%. The following steps reset the Print Scaling option so that
future worksheets print at 100%, instead of being resized to print on one page.
If necessary, display the Page Layout tab and then click the Page Setup Dialog Box
Launcher (Page Layout tab | Page Setup group) to display the Page Setup dialog box.
Click Adjust to in the Scaling area to select the Adjust to setting.
If necessary, type 100 in the Adjust to box to adjust the print scaling to a new