May 10 2023 01:37 AM
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 these areas on one sheet. How does it work?
May 10 2023 02:50 AM
To combine the two print areas into one on the same page, you can follow these steps:
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.
May 10 2023 03:55 AM
The "Add to print area" button is only available if a print area already exists.
May 10 2023 05:10 AM
If you want to print on one page, the print area will have to be a single contiguous range.
May 10 2023 05:39 AM
May 10 2023 05:51 AM
You can submit a request from within Excel: File > Feedback > Send a Suggestion.