Printing My Spreadsheet

[theberlinjrs]

At my office, I have a spreadsheet that I send to clients once a month. I would love it to fit on one printed page easily. How can I have it fit on one page? I tried making it a PDF, that didn't work. One of the columns was still off the edge. I switched it to landscape orientation, that didn't work either. Is there a way to quickly turn it into a photo or something so that it fits on one page? Does this make sense? Help!

[TMS]

Choose Page Layout | Page Setup | Click on "Fit To" 1 page(s) wide by 1 tall | Click on OK.

Select the best orientation to make the best use of the available page

Print to PDF for security.

Regards, TMS

[theberlinjrs]

My hero! Thank you!

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.