Printing multicolumn documents

[kevs]

I always like to print a document so it prints out on one page even if I
have to select landscape and push margins out.

But what it you have lot of columns -- like 15 columns. How can you get
each page of rows of info on it's own single sheet paper.
I thinking of using perhaps legal paper which I've never done before.

Any other tips?

Other than that, only thing I can think of is you have to tape sheets
together to see whole document proper, visually , which is silly to have to
do.


OS 10.3.4
Office 2004

 

[Tom Stiller]

I always like to print a document so it prints out on one page even if I
have to select landscape and push margins out.

But what it you have lot of columns -- like 15 columns. How can you get
each page of rows of info on it's own single sheet paper.
I thinking of using perhaps legal paper which I've never done before.

Any other tips?

Other than that, only thing I can think of is you have to tape sheets
together to see whole document proper, visually , which is silly to have to
do.


OS 10.3.4
Office 2004

Can you use Page Setup to scale the printout so that a row fits across
the width of the paper?

--
There are 10 kinds of people in the world:
those who understand binary, and those who don't.

Tom Stiller

PGP fingerprint = 5108 DDB2 9761 EDE5 E7E3
7BDA 71ED 6496 99C0 C7CF

 

[JE McGimpsey]

I always like to print a document so it prints out on one page even if I
have to select landscape and push margins out.

But what it you have lot of columns -- like 15 columns. How can you get
each page of rows of info on it's own single sheet paper.
I thinking of using perhaps legal paper which I've never done before.

Any other tips?

Other than that, only thing I can think of is you have to tape sheets
together to see whole document proper, visually , which is silly to have to
do.

Page Setup/Page/Fit to <blank> pages wide and 1 pages tall


Also, see David McRitchie's Snake Columns page:

http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[kevs]

Tom:
Don't understand you comment.

JE:
I tried your tip, but I got the same result on print preview. A weird
looking page with lot of squooshed rows and columns with no text in it. I'm
going to try to add attachment here, which I've never tried before in users
group.

Also, I'm having trouble even setting print area. I drag across screen from
left to right, and I'm stopped at edge of right monitor, even though there
is a lot of columns still on the right. It wont keep going. Cursor just
stops.



This below is what I see when I do a print preview:

Page Setup/Page/Fit to <blank> pages wide and 1 pages tall


Also, see David McRitchie's Snake Columns page:

http://www.mvps.org/dmcritchie/excel/snakecol.htm

OS 10.3.4
Office 2004