Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2007

Tip: Looking for answers? Try searching our database.

Page break stay on 1 printed page if room?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Al Franz - 12 Mar 2007 23:09 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.