Microsoft Office Tutorials and References
In Depth Information
Printing parts of worksheets
Printing parts of worksheets
Excel gives you a great deal of control over what your worksheets look like when you print
them, but you also have a lot of control over which parts of your worksheets will be printed.
For example, you can use the commands available on the Print page of the Backstage view
to choose which pages of a multipage worksheet you want to print.
In the Settings area of the Print page, you can fill in the page numbers you want to print in
the Pages From and To boxes.
TIP You can also use the Page Break Preview window to determine which pages to print,
and if the pages aren’t in an order you like, you can use the commands on the Sheet page
of the Page Setup dialog box to change the order in which they will be printed.
Another way you can modify how a worksheet will be printed is to have Excel fit the entire
worksheet on a specified number of pages. For example, you can have Excel resize a
worksheet so that it will fit on a single printed page. Fitting a worksheet onto a single page is a
handy tool when you need to add a sales or other summary to a report and don’t want to
spread important information across more than one page.
To have Excel fit a worksheet on a set number of pages, display the Page Layout tab and
use the controls in the Scale To Fit group. In the Width and Height lists, you can select how
many pages wide or tall you want your printout to be.
If you want to print a portion of a worksheet instead of the entire worksheet, you can
define the area or areas that you want to have printed. To identify the area of the worksheet
you want to print, select the cells with the data you want to print and, on the Page Layout
tab, in the Page Setup group, click Print Area and then click Set Print Area. Excel marks the
area with a dotted line around the border of the selected cells and prints only the cells you
selected. To remove the selection, click Print Area, and then click Clear Print Area.
Search JabSto ::

Custom Search