ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Printing question (https://www.excelbanter.com/setting-up-configuration-excel/75019-printing-question.html)

jezzica85

Printing question
 
Hi all, I have a very long worksheet, it equates to 468 pages printed. One
row extends over two pages, and I always print the top row as a header on
every page. The header goes from 1-15 on the first page and 16-32 on the
second page. Let's say I wanted to print out my long worksheet so 1-15 would
be on one side of the sheet, and 16-32 would be on the other side. Would
there be a way to do that without needing to print out half of the document,
rearrange and flip the stack, and reprint the other half?
Thanks!

Anne Troy

Printing question
 
Seems to me your best bet would be to merge this data to Word. Once you have
a mail merged document, you could set it up to print duplex or print all
odds, flip the paper, then print all evens. Save the document after you set
up the merge (but before you merge) and you should be able to merge it with
the most recent data any time you want to print it. You'll create a Catalog
(version 2000 and down) or Directory merge (2002 and up).
http://www.officearticles.com/word/m...osoft_word.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"jezzica85" wrote in message
...
Hi all, I have a very long worksheet, it equates to 468 pages printed.
One
row extends over two pages, and I always print the top row as a header on
every page. The header goes from 1-15 on the first page and 16-32 on the
second page. Let's say I wanted to print out my long worksheet so 1-15
would
be on one side of the sheet, and 16-32 would be on the other side. Would
there be a way to do that without needing to print out half of the
document,
rearrange and flip the stack, and reprint the other half?
Thanks!





All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com