Forum Discussion
How to set "Fit Sheet on One Page" as the default setting to print?
I'm just wondering if it is possible to have the "Fit Sheet on One Page" as the default printer setting. From what I gathered this used to be possible by going to File > Options > Advanced > Prin...
Yeah, that's an ad.
I know how to make it fit to one page. My issue is making it the default setting, so that I don't have to manually set it every time I print one of the thirty plus documents I print every day.
That's through VBA programming. You may check Stuart McCormack answer here Is it possible to set the default print settings in excel to always 'Fit Sheet on One Page'? - Quora