Excel Fit to One Page option

Question

Level 1

4 points

Excel Fit to One Page option

Trying my hardest to find the answer to this. In Excel there is an option to fit the data to one page thus turning multiple pages into one perfectly aligned page. Is there any way to do this in Numbers? I have tried the Sheet Inspector and the Content size and nothing works. I could manual change each column width but come one - shouldn't Numbers be able to do this in one click? I am trying to take a table the size of 4 sheets and make it one sheet in order to print one table on one sheet. Make sense? Help! Report due in 1 hour!
Thank you!!!!!

iMac, Mac OS X (10.5.1)

Posted on Feb 27, 2008 7:45 AM

Reply

Answer 1

jaxjason

Level 5

5,063 points

Feb 27, 2008 9:48 AM in response to Smith0515

Numbers doesn't do the "One click" answer. And I think I know why. Alot of times fit to one page ends up being too small for me to read. Instead of printing a wasteful page then going back to fix it, Apple gave us a print view (Like the print prview in Xl), but it is basically just a view of your page that is still workable as a workbook, but breaks it up onto multiple pages as it would print, use the slider at the bottom to scale the worksheet till it is readable on the minimum pages you need.

Reply

Answer 2

Feb 27, 2008 9:03 AM in response to Smith0515

Smith,

You have the Content Scale Slider in Print View. With this you can reduce the scale to as low as 25% of normal. This may be enough to get everything on one page. If not, it's time to start shrinking the content in other ways. This control is in the lower left portion of the main window.

Jerry

Message was edited by: Jerrold Green1

Reply