Printing Separate Print Areas

If you need to print a number of separate print areas from the one worksheet in one step there is an option that allows you to create a print area that includes additional ranges.

Create your first print area as per normal.

Select another print range and click the Page Layout ribbon and use the Print Area drop down and choose Add to Print Area. Keep adding ranges as you require.

You can also use the Ctrl key and mouse to select multiple separate ranges and then use Set Print Area.

The above technique allows you to add to that Print Area if you miss a range.

Downside

The only problem with this option is that each separate range is printed on a separate page(s).

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *