I would guess that the A to BT is where the scaling is occuring, the 83
rows is an easy fit when you compress the columns to fit. Spread it out
to 3 pages wide or so.

Laphan wrote:

Hi All

Complete newbie so please bear with me.

Basically I've been given a worksheet that uses columns A to BT and although
the columns are quite narrow, ie a lot have a single value in them, when I
try and print this doc in 0.5 margins A4 landscape using the format 1 page
wide and 2 tall I get all of the data, but its far too small to read.

I'm not bothered if the rows go on multiple pages, current worksheet uses 83
rows, but I need all my columns to show.

What the problem seems to be is that the scaling options in Excel are
proportional so when I state 1 page across it doesn't matter how many tall I
do the whole sheet (rows and cols) are proportionally scaled to get all the
columns and rows onto 1 page, which is why it's so small.

Is there any way I can shrink to get the cols on, but leave the rows to flow
onto as many pages as needed so that I don't get the magnifying glass
effect?

Thanks