 |
 |
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