Hey Charles –
Adjusting the margins to Narrow (.75” each side) should fit all 8 columns on a single 8.5x11” while allowing the contents to be readable (user experience may vary and all that).
If you also need all 55 rows on a single page, you can then set the row height to 13 for all of them or manually adjust the top & bottom margins to .25” and the row size to 14 or 15. Depending on the printer, small margins may cause cut off.
Either way, don’t forget to mark “center horizontally / vertically” for aesthetics!
Aside from those settings, I’m afraid I’m not aware of an easy fix, but hopefully it helps. :)
Be well,
Andrew
From: Code for Libraries <[log in to unmask]> on behalf of charles meyer <[log in to unmask]>
Date: Monday, October 17, 2022 at 2:15 PM
To: [log in to unmask] <[log in to unmask]>
Subject: [External] [CODE4LIB] Excel - Printing
Hi my esteemed listmates,
I hope you are all doing well.
I’m back at one of our branches to help the public with a variety of
challenges after Hurricane Ian.
It was so rewarding being the communication center collaborating with the
Red Cross and addressing a myriad of community needs. Really, a lot like
what we do at the public library daily! 😊
Our main branch sustained a lot of damage and we don’t know how the county
will proceed in re-building or otherwise. In the meantime, I’m acquainting
myself with different equipment and tech at this other branch.
I have a pressing Excel matter. I created a worksheet with 8 columns across
the top and 55 rows down along both with plain text in them, respectively.
When I print, to get all the columns across the top on one page I have to
adjust the Scaling down to 50% Landscape (Portrait is even worse). That
prints all the text (date) in each cell so tiny you need a magnifying glass.
How might I make other setting adjustments so I get all 8 columns
(headings) on one page but with readable size of the contents in each cell?
Thank you kindly,
Charles.
Charles Meyer
Charlotte County Public Library
Port Charlotte, Fl
|
