Forum Home
Press F1
 
Thread ID: 11437 2001-09-18 22:11:00 Portrait or Landscape? Guest (0) Press F1
Post ID Timestamp Content User
19023 2001-09-18 22:11:00 Is it possible in Excel (XP Edition) to have say 10 of your 11 pages of a document Portrait and the 11th Landscape? Guest (0)
19024 2001-09-19 05:31:00 Not familiar with XP but with 97.
If you print from a macro, you can change the page orientation using VB code.

Use the macro recorder, and record the two different page orientations, to get the correct syntax to incorporate into a print macro.
Guest (0)
19025 2001-09-20 02:49:00 I suppose you COULD do it with a macro, but why not just set the orientation to portrait, print off page range 1-10, then set it to landscape and print off only page 11? Guest (0)
19026 2001-09-20 03:53:00 The page orientation for each sheet is stored separately in excel. Portait is the default setting but you can select landscape by clicking on a sheet then going to File, Page Setup, and selecting landscape for the orientation. Guest (0)
1