Microsoft Office Tutorials and References
In Depth Information
Renaming and Reordering the Sheets and Coloring their Tabs
To Preview and Print the Workbook
Conserving Ink
and Toner
If you want to conserve
ink or toner, you can
instruct Excel to print draft
quality documents by
clicking File on the Ribbon
to open the Backstage
view, clicking Options in
the Backstage view to
display the Excel Options
dialog box, clicking
Advanced in the left pane
(Excel Options dialog box),
scrolling to the Print area
in the right pane, placing
a check mark in the ‘Use
draft quality’ check box,
and then clicking the OK
button. Then, use the
Backstage view to print
the document as usual.
After checking the spelling, the next step is to preview and print the sheets. As
with spelling, Excel previews and prints only the selected sheets. In addition, because the
worksheet is too wide to print in portrait orientation, the orientation must be changed to
landscape. The following steps adjust the orientation and scale, preview the workbook,
and then print the workbook.
1
Ready the printer. If both sheets are not selected, hold down the CTRL key and then click
the tab of the inactive sheet.
2
3
Click File on the Ribbon to open the Backstage view.
Click the Print tab in the Backstage view to display the Print gallery.
4
If necessary, click the Portrait Orientation button in the Settings area and then select
Landscape Orientation to select the desired orientation.
5
If necessary, click the No Scaling button in the Settings area and then select ‘Fit Sheet on
One Page’ to cause the workbook to print on one page.
6
If necessary, click the Printer Status button to display a list of available Printer options
and then click the desired printer to change the currently selected printer.
7
Click the Print button in the Print gallery to print the worksheet in landscape orientation
on the currently selected printer.
8
When the printer stops, retrieve the printed worksheet (Figure 3 – 74a and Figure 3 – 74b
on the following page).
9
Right-click the Six-Month Financial Projection tab. Click Ungroup Sheets on the shortcut
menu to deselect the 3-D Pie Chart tab.
10
Save the workbook.
Printing Document
Properties
To print document
properties, click the File
on the Ribbon to open
the Backstage view,
click the Print tab in
the Backstage view to
display the Print gallery,
click the i rst button
in the Settings area to
display a list of options
specifying what you can
print, click Document
Properties in the list
to specify you want
to print the document
properties instead of
the actual document,
and then click the Print
button in the Print
gallery to print the
document properties on
the currently selected
printer.
Figure 3 –74 (a) Worksheet
 
Search JabSto ::




Custom Search