Hi, I cannot find a solution to the problem of not being able to set multiple print areas in my worksheet to print as pages in a PDF format. This is optional. If you want to add another print area, you need to select this area, and then click the Page Layout > Print Area > Add to Print Area. Click the File (or Office button) > Print to print these print areas. Notes: (1) Each print area will be printed in a separate page.
Print selected cells. Select the cells that you want to print. On the File menu, click Print. In the Print box, click Selection in the drop-down list.
Click Print. Set a print area Excel saves the print area together with the workbook. Select the cells that you want to print. On the File menu, point to Print Area, and then click Set Print Area.
On the File menu, click Print. Add cells to an existing print area. Select the cells that you want to add to the existing print area.
The cells that you select don't have to be next to the existing print area. On the File menu, point to Print Area, and then click Set Print Area. On the File menu, click Print. Clear a print area. On the File menu, point to Print Area, and then click Clear Print Area. Print selected cells. Select the cells that you want to print.
On the File menu, click Print. Under Print What, click Selection. Click Print. Set a print area Excel saves the print area together with the workbook. Select the cells that you want to print.
On the File menu, point to Print Area, and then click Set Print Area. On the File menu, click Print. Add cells to an existing print area. Select the cells that you want to add to the existing print area. The cells that you select don't have to be next to the existing print area.
On the File menu, point to Print Area, and then click Add to Print Area. On the File menu, click Print. Clear a print area. On the File menu, point to Print Area, and then click Clear Print Area.