Why so many pages on one spreadsheet

Question

Level 1

0 points

Why so many pages on one spreadsheet

When I create a spreadsheet, all fits on one page. However, on the left side it may say I have 2 pages or even 4. When I print sheet, all 4 pages print, but only one has the content I put in, the other three are almost blank or may print part of the top row or left column.

Powerbook G4, Mac OS X (10.4.11), laptop

Posted on Sep 4, 2008 2:52 PM

Reply

Answer 1

WWJD

Level 6

15,830 points

Sep 4, 2008 4:42 PM in response to kendonw

The dimensions of your sheet can be variable. Do you have unused cells? If so, grab the table sizer (lower RH corner of table), and remove cells. You can also set the sheet magnification when printed by using Page Preview (Pint Preview) mode and select the magnification.

Regards,

Reply

Answer 2

pw1840

Level 3

860 points

Sep 4, 2008 6:50 PM in response to kendonw

kendon,

To expand on WWJD's answer I might add that it's wise to preview your page before printing. (Go to Main Menu > View > Show Print View.) This will allow you to see if your table extends to additional pages and you can then decide how to get the table fit on one page. In addition to suggestions from WWJD, you may consider changing margin sizes and cell widths.

pw

Reply

Answer 3

kendonw Author

Level 1

0 points

Sep 5, 2008 8:46 AM in response to pw1840

Thanks to both of you...I think I got it figured out.

Reply