 |
 |
If you're willing to have rows on multiple pages (as long as all 8 columns fit on a single page), you could also decrease the cell width, increase the cell height, and allow text wrapping. On Mon, Oct 17, 2022 at 5:03 PM Battelini, Andrew John <[log in to unmask]> wrote: > 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 > -- Jackson Huang Digital Collections and Content Ingest Coordinator Library Information Technology University of Michigan Library