Page format in excel...

  • Thread starter Thread starter confused man
  • Start date Start date
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
 
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
(e-mail address removed)
 
Back
Top