Print multiple pages on one sheet
 

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.

Print multiple pages on one sheet
 

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

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.

Print multiple pages on one sheet
 

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


"Dorci" wrote:

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.

Print multiple pages on one sheet
 

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

"bj" wrote:

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


"Dorci" wrote:

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.

Print multiple pages on one sheet
 

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


"Dorci" wrote:

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.

Print multiple pages on one sheet
 

That works. Thanks!

"bj" wrote:

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

"bj" wrote:

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


"Dorci" wrote:

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.