Forum Discussion
multiple print areas
Hi, I have a print range A1:N35 and I want to add cells A36:D40. These are adjacent cells. Excel treats this as 2 print areas and outputs the added area on the 2nd page. But I would like to have thes...
To combine the two print areas into one on the same page, you can follow these steps:
- Select the first print area (A1:N35).
- Hold down the Ctrl key on your keyboard and then select the additional cells you want to include in the print area (A36:D40).
- With both print areas selected, go to the Page Layout tab in the Excel ribbon and click on the Print Area dropdown.
- Select "Add to Print Area" from the dropdown menu. This will add the second print area to the first one.
- Now, when you go to print the worksheet, both print areas will be on the same page.
Alternatively, you can try adjusting the print settings such as reducing the scaling factor, margins, and orientation to fit the entire range into one page.
Note that the print quality may be affected if you try to fit too much data onto a single page.
The "Add to print area" button is only available if a print area already exists.
