Print to full page

**monkeyhouse** · 03-17-2010, 07:56 PM

How can I stretch a spreadsheet to fit the page? If I try to make it one page by one page, it changes nothing. If I change the percentage, it becomes two wide...I am just trying to change the height so that it can be read on an 8.5 x 11 piece of paper.

**oldchippy** · 03-17-2010, 08:03 PM

Hi,

Go into page set-up and fit 1 wide x 1 tall and change the paper size to A4. Then drag out the borders as far as possible, but I think it will still be to small to read?

**monkeyhouse** · 03-17-2010, 09:09 PM

That's just it, I don't have anything I can grab and pull. The only option I have is to move it.

**shg** · 03-17-2010, 09:18 PM

Autofit the width of col A, delete col B, and set the width of the rest of the columns to 2.5.

Then do Page Setup, set the L & R margins to as small as your printer will allow, and fit to 1 page wide by 1 page tall.

It's small, but readable.

Please don't quote whole posts.

**monkeyhouse** · 03-17-2010, 09:25 PM

why is the quote function there if you're not supposed to use it??

**shg** · 03-17-2010, 09:27 PM

For clarity, in the case when you're replying to a post earlier in the thread -- and then you delete all but the relevant lines.

**monkeyhouse** · 03-17-2010, 09:41 PM

yeah, that's what I was doin, making sure the person knew I was talking to him...pretty self explanatory. Uh yeah, making the columns 2.5 means they don't print...any other suggestions??