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 <CODE4LIB_at_LISTS.CLIR.ORG> on behalf of charles meyer <reachmeplace_at_GMAIL.COM>
Date: Monday, October 17, 2022 at 2:15 PM
To: CODE4LIB_at_LISTS.CLIR.ORG <CODE4LIB_at_LISTS.CLIR.ORG>
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
Received on Mon Oct 17 2022 - 16:40:39 EDT