Getting a spreadsheet to fit on one page.

Question

Level 5

4,422 points

Getting a spreadsheet to fit on one page.

Hello Humans,

I know this is an easy one, but I never use spreadsheets.
I have an .xls file that was emailed to me. When I print it, it wants to split it up into several pages. This is basically a simple order form which I should be able to fit two on a single sheet of paper.

How do I resize it so it fits on one page, or better yet two on one page.

Thanks for your help in advance.

bd

eMac 1.25GHz SD, 768 MB, Mac OS X (10.4.4), 200GB LaCie; Canon Elan7e, A80, ZR70; iPod Mini; Treo600; and a dusty iMac 350

Posted on Feb 9, 2006 10:58 AM

Reply

Answer 1

Ken.

Level 6

10,225 points

Feb 9, 2006 5:56 PM in response to briandallas

There's no easy answer since there's a few variables to consider. Assuming that the xls file translated neatly and all the columns, rows and fonts look normal, AW does not have the same "make it fit" function that Excel has. However, under Page Setup, there is a scale command. Also, make sure the print range is correct. This is under Options, Set Print Range.

If this still is not quite working right, a down and dirty trick is to convert the file to a PDF using File, Print, PDF, Save As PDF. Open this new PDF file in Adobe Reader (not Preview). There are all sorts of page layout functions in the Print dialog box.

Reply

Answer 2

briandallas Author

Level 5

4,422 points

Feb 9, 2006 10:03 PM in response to Ken.

Thanks for the response Ken.

"There's no easy answer"

I was afraid of that!

The rows and columns don't look normal so maybe the translation is the problem.

I tried setting the print range, adjusting the scale, changing the page setup, and nothing was printing correctly.

I had even thought of saving it as a PDF and Photoshopping it. But then I read your post about opening it with Acrobat Reader. That worked GREAT! It opened up looking the way it should and it printed great.

Thanks a million.

bd

Reply

Answer 3

Ken.

Level 6

10,225 points

Feb 10, 2006 3:48 AM in response to briandallas

So many of the tiny details often fail to translate between programs and data formats. The same printer and/or font on a different OS can even affect formatting. PDF can sometimes get past the quirks....

Reply

Answer 4

briandallas Author

Level 5

4,422 points

Feb 10, 2006 7:02 AM in response to Ken.

It's good to know that.
Given that "quirk" and the fact that I don't know my way around AW (much less a spreadsheet) had me pulling my hair out. I needed that form by this morning.
Thanks to you I have it.

Take care.

bd

Reply