Page format in excel...

C

confused man

Hello all,

I'm working on a sheet that I have set up to print in landscape format.
which is just what I want for the first 12 pages... but I need the next two
pages to print in regular Portrait format. This is all in one sheet. Is
there any way to do that?

Thanks to all,
Confused Man
 
N

Nick Hodge

You could only do this with two print jobs. Print 1-5 and then change the
settings. (This could be done in code) and then print 6 & 7. You can get
continuous numbering by changing the 'first page number' on the sheet tab in
File>Page setup... to 5

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top