Hey all, thanks again in advance for the help.
I was wondering if it was possible to do what I had in mind with out a macro or a very simple macro but in all honesty I would rather not use a macro and hope I just don't know something about Excel.
I have a very wide document. Going many columns across. This is fine when using the document on the computer but when printed out it is very difficult to read or goes across multiple sheets. I was wondering if it is possible to have data wrap onto the first printed page as an optimal way for me to "fit to page". I know it isn't ideal but it would be much easier on everyone's eyes.
For example:
[A1][B1][C1][D1][E1][F1]
[A2][B2][C2][D2][E2][F2]
[A3][B3][C3][D3][E3][F3]
With a page break between columns C and D would print like this:
[A1][B1][C1] [D1][E1][F1]
[A2][B2][C2] [D2][E2][F2]
[A3][B3][C3] [D3][E3][F3]
What I want is this:
[A1][B1][C1]
[D1][E1][F1]
[A2][B2][C2]
[D2][E2][F2]
[A3][B3][C3]
[D3][E3][F3]
on one or more pages, extra pages would be going vertically not horizontal.
Thanks!
Bookmarks