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