Spreadsheet too big to fit landscape, letter size paper

[uby]

Hey Everyone!

I'm wondering if this is even possible.

I have an Excel spreadsheet that has various columns. Too many columns to fit a landscape, letter size paper.

Is it possible to get the remaining columns that do not fit on the page to go to the next available row and slap the remaining columns there? And if so, will this require code?

Ex:

Col A Col B Col C Col D Col E Col F






Col G Col H Col I so on and so forth.

Help!


Uby

 

[PHV]

You may try this:
ActiveSheet.PageSetup.Order = xlOverThenDown

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[uby]

Thank you for responding PHV.

I will try this.

Uby