Print adjacent ranges on separate pages.

[Audiology]

In Excel 2010, when I assign adjacent ranges as comma-separated print areas, they inevitably concatenate into one continuous print range.

How can I sequentially print one adjacent area per page? i.e C1:M27, C28:M57, ...etc.

 

[Audiology]

Re: Print adjacent ranges on separate pages. Ans.

Workaround:

1. Set page breaks at the bottom of each vertically adjacent range.

2. Highlight the entire area including all vertically adjacent ranges to be printed.

Problem solved