Saving workbook to PDF: how to fit all columns of each tab on its own page

[Kabouterke]

Hi there. I have a 50-tab workbook I'd like to publish as PDF. How to save the workbook as a PDF is no problem. However, I haven't see any option to say "fit all columns on page" like you get when you print a physical copy.

Does anyone know of any (non-coding) ways to save a workbook to PDF and tell it to fit all columns on each tab as a page?

Thanks!

[Alf]

Try under print setting -> No scaling click down arrow and select "Fit all columns on one page"

Alf

[Kabouterke]

Oh, well that was a ridiculously easy fix. Thanks!

[Alf]

You are welcome.

Don't forget to mark thread "Solved" as pr forum rules.

Alf

Ps

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved