 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / April 2007Printing an Excel Doc from Head to Toe?
Does anyone know if it's possible to setup an Excel document in Excel so it prints (or is laid out) from Head to Toe? I have these massive documents I need to put into books and organize this way. I have tried finding this functionality in Acrobat, unsuccessfully, so I thought there might be a way to set this up with the source document (Excel). Any help most appreciated! Thanks, Stuart Still hoping someone might have some insight into if this is possible. Thanks, Stuart On Apr 28, 5:44 pm, stuartba...@gmail.com wrote: > Does anyone know if it's possible to setup an Excel document in Excel > so it prints (or is laid out) from Head to Toe? I have these massive [quoted text clipped - 8 lines] > > Stuart Could be we're not sure what "head to toe" means. At least I'm not sure, for one. Could you give us a better description of your present layout...sheets.....columns.......rows......and how you need it presented upon printing into book form. Gord Dibben MS Excel MVP >Still hoping someone might have some insight into if this is possible. > [quoted text clipped - 15 lines] >> >> Stuart > Could be we're not sure what "head to toe" means. > [quoted text clipped - 28 lines] > > >> Stuart Thanks, Gord. What I mean by head to toe is that when you print double sided, place the page in a loose leaf notebook, and flip from Page 1 to Page 2, the 2nd page doesn't read upside down, but right side up, because the 2nd page was printed in the opposite direction of page 1 - head to toe if you will. So front and back are not matching, but on opposite ends. Thanks again, Stuart Hi Stuart, What you're referring to is a duplexing option for your printer and is controlled via your print driver's controls. Ordinarily, you'd set this via Start|Printers from the main Windows screen, or via File|Print|Advanced from whatever application you're working in. This is not something that's normally controlled by Excel - though it could be done via a macro. Cheers  Signaturemacropod [MVP - Microsoft Word] ------------------------- >> Could be we're not sure what "head to toe" means. >> [quoted text clipped - 39 lines] > > Stuart Correct. I know how it would ordinarily be done, but I can't seem to get this to function via the windows print drivers, unless you know of a way. What I was hoping for were some instructions for how to set this up via a macro. Any suggestions most appreciated. Thanks, Stuart > Hi Stuart, > [quoted text clipped - 52 lines] > > > Stuart You could run through and print Odd pages then flip the sheets over and print the Even pages. Code provided at Ron de Bruin's site. http://www.rondebruin.nl/print.htm#odd Gord >Correct. I know how it would ordinarily be done, but I can't seem to >get this to function via the windows print drivers, unless you know of [quoted text clipped - 61 lines] >> >> > Stuart Hi Stuart, Exactly how its done depends on the particular printer you're using - there's no 'universal' way. Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > Correct. I know how it would ordinarily be done, but I can't seem to > get this to function via the windows print drivers, unless you know of [quoted text clipped - 62 lines] >> >> > Stuart |
Reply to this Message |
 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.