Print Wrap/Formatting for Printing?

[RaydenEG]

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!

[Paul]

Hi Rayden,

I think the only way you're going to accomplish that is via macro to re-organize your data, print it, then set it back the way it was. (Or create a copy of the worksheet, re-org that data, print it, delete the temp sheet - so you're not messing with your live data.)

[RaydenEG]

That's a shame. It would be very convenient. I am reluctant to write a macro but unfortunately that might be the best solution.

thanks.

[Paul]

The following macro, placed in your main data sheet, might suit your needs. You may need to adjust the Sheet names and columns to match your data layout, but it should give you a good start. If you have questions let us know (at which point we'll probably ask you to upload your workbook, or a copy of it minus any private data).

Please Login or Register  to view this content.

[RaydenEG]

Very helpful! I have been able to work with the macro and get it to work. Thanks!