Print a selected area of a worksheet
- On the View menu, click Page Break Preview.
- Select the area you want to print.
- On the File menu, point to Print Area, and then click Set Print Area.
When you save the document, your print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) selection is also saved.
Add cells to an existing print area
- On the View menu, click Page Break Preview.
- Select the cells you want to add to the print area.
- Right-click within the selection, and then click Add to Print Area.
Center worksheet data on the printed page
- Click the worksheet.
- On the File menu, click Page Setup, and then click the Margins tab.
- To center worksheet data horizontally on the page between the left and right margins, select the Horizontally check box under Center on page.
To center worksheet data vertically on the page between the top and bottom margins, select the Vertically check box under Center on page.
Clear a print area
- On the File menu, point to Print Area, and click Clear Print Area.
United Kingdom
Printer-Friendly Version
Hide All
