Adding to the print range
After defining a print range, you can add more cells to it. This allows multiple, separate areas of the same sheet to be printed, while not printing the whole sheet. After you have defined a print range:
- Highlight the range of cells to be added to the print range.
- Choose Format > Print Ranges > Add. This adds the extra cells to the print range.
The page break lines no longer display on the screen.
|| The additional print range will print as a separate page, even if both ranges are on the same sheet.