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.

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.

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.

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.

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.

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.