Section breaks for page formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1974379%22%20slang%3D%22en-US%22%3ESection%20breaks%20for%20page%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1974379%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20insert%20page%20breaks%20in%20Excel%20and%20can%20do%20it%20but%20there%20is%20a%20Page%20Layout%20section%20that%20keeps%20overriding%20my%20formatting.%20I%20would%20like%20to%20have%20a%20separate%20Page%20Layout%20on%20each%20tab-%20i.e.%20set%20the%20number%20of%20pages%20in%20each%20Tab%20before%20PDFing%20the%20whole%20book.%26nbsp%3B%20On%20one%20tab%20I%20would%20select%201%20page%20wide%20x%201%20page%20high%20and%20the%20next%20tab%20might%20be%201%20page%20wide%20x%203%20pages%20but%20they%20all%20seem%20to%20use%20the%20same%20scale.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20anyone%20have%20any%20ideas%3F%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1974379%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

0 Replies