Print multiple pages on one sheet

G

Guest

I have a spreadsheet that is 41 columns wide but only 10 rows long. Because
it's so wide, it prints to 2 or 3 pages. If I select "fit to 1 page", the
font is too small to read. Can I get it to wrap the additional pages onto
the same sheet?

In the Page Setup there's a Page Order section that says "Down, then over"
vs. "Over, then down", which looks like what I want, but I don't see how to
utilize the option.

Thanks in advance for your suggestions.
 
G

Guest

don't think you can do that. The over-down, down-over refers to sheets that
are WIDER than 1 page and where the rest of the stuff on the right prints
 
G

Guest

your best bet is to add a new sheet just to print from
format this sheet as you want it and link to your original shhet
 
G

Guest

depending on your printer, you might be able to tell it to print 4 pages per
sheet, this might do what you want.
 
G

Guest

Have you tried transposing your data? (Select all data | Copy | Edit | Paste
Special | transpose).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printed multiple pages per sheet 4
Excel: Narrow print area to wrap to 2nd "column" on page 1
Printing Multiple pages one one page 2
how do I print multiple print areas on one page 1
Setting print area 1
Pages Per Sheet 2
Print preview/page set-up is printing 100's of blank pages 2
Not all pages printing in Excel 2007 1

Top