Microsoft Office Tutorials and References
In Depth Information
Printing Sections of the Worksheet
4 Select cell E2, type 5.75 and then press the DOWN ARROW key.
5 In cell E3, type 18 and then click the Enter box in the formula bar or press the ENTER key to
complete the entry of the original load data. Select cell H22.
In Chapter 2, you learned to print a section of a worksheet by selecting it and using the
Selection option in the Print dialog box (see page EX 134). If you ﬁ nd yourself continually
selecting the same range in a worksheet to print, you can set a speciﬁ c range to print each
time you print the worksheet by using the Set Print Area command. When you set a range
to print using the Set Print Area command, Excel will continue to print only that range
until you clear it using the Clear Print Area command.
This section describes print options available in the Sheet sheet in the Page Setup dialog box (Figure 4–47).
These print options pertain to the way the worksheet will appear in the printed copy or when previewed. One of the
more important print options is the capability of printing in black and white. Printing in black and white not only
speeds up the printing process, but also saves ink. This is especially true if you have a color printer and need only
a black and white printed copy of the worksheet. The following steps ensure any printed copy ﬁ ts on one page and
prints in black and white.
• Click the Page
Layout tab on the
Ribbon and then
click the Page Setup
Dialog Box Launcher
on the Ribbon.
set to Portrait
• When Excel displays
the Page Setup
dialog box, click the
Page tab and then
click Fit to in the
Scaling area to set
the worksheet to
print on one page
Fit to option