To define part of a worksheet as the only part that will print, open page break preview. Select the area you want to print, and on the File menu, point to Print Area. Click Set Print Area. When you save the workbook, the defined print area is saved.
Print part of your data
Say you want to print just part of your data, not the whole worksheet. Perhaps you want to print cells C7 through C16, or the results of one calendar quarter, or the products from one supplier. How do you do that?
Select the area you want to print. Then, on the File menu, click Print. Under Print what, click Selection. Then click OK.
If you expect to print a particular area of a worksheet frequently, it's convenient to define and save it as a print area.
To do that, on the View menu, click Page Break Preview. Select the area that you expect to print often. Next, on the File menu, point to Print Area, and then click Set Print Area. When you save the workbook, your defined print area is also saved. You can save only one defined print area at a time on a worksheet.
When you're ready to print, on the File menu, click Print. Only the defined print area will be printed.
If you decide later that you want to print the entire worksheet, you must clear the defined print area. On the File menu, click Print Area. Then click Clear Print Area. Use the same process to change the defined print area.
- Even after you've defined a print area, you can still print a different area on the same worksheet. Select the area, and then on the File menu, click Print, then click Selection under Print what in the Print dialog box.
- Set Print Area does not work if a chart is selected.
Print more than one worksheet in the same job
You can print more than one worksheet at the same time. When you're ready to print, press CTRL, and click the tab of each worksheet that you want to print. Then, on the File menu, click Print. In the Print dialog box, under Print what, click Active sheet(s). All the worksheets that you selected will print at the same time. If you have defined print areas in those worksheets, only the defined areas will print.
You can also print more than one workbook at a time — if the workbooks are all in the same folder. On the File menu, click Open. Find the folder with the workbooks you want to print. Select the first workbook to print, then press CTRL, and select each workbook to print. Click the Tools menu in the Open dialog box, and then click Print.