Microsoft Office Tutorials and References
In Depth Information
Displaying and Printing the Formulas Version of the Worksheet
1
Press CTRL + ACCENT MARK (`) to display the worksheet with formulas.
Tap or click the right horizontal scroll arrow until column J appears (Figure 2 – 67).
Page Setup Dialog
Box Launcher
formulas displayed
instead of values
Figure 2 – 67
2
Tap or click the Page
Setup Dialog Box
Launcher (PAGE
LAYOUT tab | Page
Setup group) to
display the Page
Setup dialog box
(Figure 2 – 68).
Page Setup
dialog box
Landscape option
button selected
If necessary, tap or
click Landscape in
the Orientation area
in the Page sheet to
select it.
Fit to option button
If necessary, tap
or click Fit to in
the Scaling area to
select it.
Print button
Figure 2 – 68
3
Tap or click the Print button (Page Setup dialog box) to print the formulas in the worksheet on one page in
landscape orientation (Figure 2 – 69). If necessary, in the Backstage view, select the Print Active Sheets option
in the Settings area of the Print gallery.
When Excel opens the Backstage view, tap or click the Print button to print the worksheet.
 
Search JabSto ::




Custom Search