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.
Printing Sections of the Worksheet
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 fi nd yourself continually
selecting the same range in a worksheet to print, you can set a specifi 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.
To Set Up a Worksheet to Print
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 fi 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.
Page Setup
Dialog Box
Page Setup
dialog box
set to Portrait
Page tab
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
(Figure 4–47).
Fit to option
Figure 4–47
Search JabSto ::

Custom Search