Besides the comments about page margins (which I highly recommend; I usually set mine to 0.25”, possibly with a 0.5” on the gripper side (where the printer grabs the paper)), you can also check to see if there’s an option on the cell formatting for margins there, so the text fits more of the cells. You’ll then need to adjust the width of the columns as best you can.
But really, if you’re going to be doing much of this, I’d recommend getting a ream of ‘legal’ sized paper. It’s still 8.5” wide, so will work on any printer that has a bypass feed, but it’s 14” long, so can fit an extra 3” of content.
If you have high end printers, take a look in the paper feed to see if it can handle ‘tabloid’ sized paper, which is 11”x17”. (But a warning: most don’t these days)
-Joe
Sent from a mobile device with a crappy on screen keyboard and obnoxious "autocorrect"
> On Oct 17, 2022, at 2:15 PM, charles meyer <[log in to unmask]> wrote:
>
> 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
|