Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Excel - format for a print option

Posted by Pam on October 12, 2001 8:43 AM

I want to print multiple pages of a sheet to one page. The data I need only covers 5 narrow columns, and I'd like to print it so I can get more than one page of data on one page vertically. Page set-up d isn't helping........ I can cut and paste, but if I could just get it to print in "columns like a Word doc it would be much faster.

Re: Excel - format for a print option

Posted by Dan on October 12, 2001 8:52 AM

How about hiding the columns you don't want to print?

Re: Excel - format for a print option

Posted by pam on October 12, 2001 9:10 AM

Did that - the columns showing are the ones I want to print, it's that I want to be able to format the print like you can in Word where you can insert "column breaks" and have the text wrap to the available area on the printed page. Maybe I'm not explaining this well.......

Re: Excel - format for a print option

Posted by Todd on October 12, 2001 10:01 AM

What about sending the data directly to Word? You could start by making a new word document, and formatting the columns just how you like. Then save, e.g. as "c:\columns.doc". Then inside a Excel macro, use .Documents.Add "c:\columns.doc". You can then insert the data, print, and close Word.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.