What-If Analysis, Charting, And Working With Large Worksheets Page 59
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 195
Conserving Ink
To Preview and Print the Workbook
and Toner
If you want to conserve
After checking the spelling, the next step is to preview and print the sheets. As
ink or toner, you can
with spelling, Excel previews and prints only the selected sheets. In addition, because the
instruct Excel to print draft
worksheet is too wide to print in portrait orientation, the orientation must be changed to
quality documents by
landscape. The following steps adjust the orientation and scale, preview the workbook,
clicking File on the Ribbon
to open the Backstage
and then print the workbook.
view, clicking Options in
the Backstage view to
1
Ready the printer. If both sheets are not selected, hold down the
key and then click
CTRL
display the Excel Options
the tab of the inactive sheet.
dialog box, clicking
Advanced in the left pane
2
Click File on the Ribbon to open the Backstage view.
(Excel Options dialog box),
3
scrolling to the Print area
Click the Print tab in the Backstage view to display the Print gallery.
in the right pane, placing
4
If necessary, click the Portrait Orientation button in the Settings area and then select
a check mark in the ‘Use
draft quality’ check box,
Landscape Orientation to select the desired orientation.
and then clicking the OK
5
If necessary, click the No Scaling button in the Settings area and then select ‘Fit Sheet on
button. Then, use the
Backstage view to print
One Page’ to cause the workbook to print on one page.
the document as usual.
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 fi 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
Figure 3 –74 (a) Worksheet
printer.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education