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 - 13 Mar 2007 02:37 GMT
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.

Signature
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
> 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.
Dave Peterson - 13 Mar 2007 02:43 GMT
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
> 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.

Signature
Dave Peterson
David McRitchie - 13 Mar 2007 04:11 GMT
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> 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.