Page break stay on 1 printed page if room?

[Al Franz]

If you are printing a long thin spreadsheet, is there anyway to print it so
that it would wrap around and continue printing on the same page? Instead
of just using the top 10% of several pieces of printed paper.

 

[Earl Kiosterud]

Al,

In a word, no. Excel, except for the accoutrements in Page Setup (headings, etc.) prints
sheets as is. You could make another sheet with links to the original, organized as you
want. Copy pieces from the original sheet and paste link them into the print sheet (Edit
(or right-click) - Paste special - Paste link). Using View - Page Break Preview (instead of
Normal) will be helpful.

 

[Dave Peterson]

I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. With lots of data, I sometimes have to paste into Notepad
first--large tables cause me trouble in MSWord.

If that doesn't work for you, David McRitchie has a macro that will "snake" the
columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[David McRitchie]

Hi Al,
Excel does not provide for that but you can use a macro.

See SNAKECOLS, How to snake columns to use fewer pages
http://www.mvps.org/dmcritchie/excel/snakecol.htm

The macros are actually geared to working with few columns
for many rows, rather than a few rows and many columns.
but you can probably work it out. Or you could paste into
MS Word.