Is there some reason you can't set the entire print range at once? Are the 5
ranges discontiguous?

If that's the problem, name each of the 5 ranges, something like Page1,
Page2, etc. Then go to File -> Page Setup and navigate to the Sheet tab. In
the Print Area box type all the range names separated by commas:

page1, page2, page3, page4, page5

Now each range will print on a separate page.

"Scudo" wrote:

> On a spreadsheet due to the size of it takes 5 pages to print it off.
> Currently I `set` each page as a print area then print so I have to do this
> 5 times in order to print off the full spreadsheet page. Is there a way to
> press `print` and it will print off the 5 pre set `print areas` ? without me
> having to go throught the `set print area` / `print`/`clear print area` then
> reset for next section.
>
> thanks
>
>
>