Hi there,
I am trying to insert page breaks in Excel and can do it but there is a Page Layout section that keeps overriding my formatting. I would like to have a separate Page Layout on each tab- i.e. set the number of pages in each Tab before PDFing the whole book. On one tab I would select 1 page wide x 1 page high and the next tab might be 1 page wide x 3 pages but they all seem to use the same scale.
Would anyone have any ideas?
Many thanks
