stevebausch
Well-known Member
- Joined
- May 11, 2002
- Messages
- 810
Mr D posted a query about keeping Landscape headers/footers while printing in Portrait mode.
Easy way to do this is to print Landscape, but have everything aligned 90 degrees; using Columns as Rows, Rows as Columns.
This is easy enough to talk about, but it's easy to get confused about where to place each cell's value. Transpose isn't adequate, at this point it seems to require a cell-by-cell Copy/Paste, and setting the Orientation to 90 degrees on each cell, after the Paste.
I don't mind the weekend project, I don't mind if anyone beats me to it, I don't mind if a 'net search turns one up.
Just Wondering: Anyone interested?
Easy way to do this is to print Landscape, but have everything aligned 90 degrees; using Columns as Rows, Rows as Columns.
This is easy enough to talk about, but it's easy to get confused about where to place each cell's value. Transpose isn't adequate, at this point it seems to require a cell-by-cell Copy/Paste, and setting the Orientation to 90 degrees on each cell, after the Paste.
I don't mind the weekend project, I don't mind if anyone beats me to it, I don't mind if a 'net search turns one up.
Just Wondering: Anyone interested?
