Jul 26 2022 07:08 AM
Jul 26 2022 07:08 AM
Hi, I have to print a lot of Excel documents at work and in order to print the documents I always have to change the printing settings to my liking and needs. The question is, is there any way to save my print options and make it a default so I can save time when printing documents in excel.
Jul 26 2022 07:45 AM
I have to print a lot of Excel documents at work and in order to print the documents I always have to change the printing settings to my liking and needs.
WHERE do you make those adjustments to your preferences? In Excel, or in the general print dialog box?Are you on PC or Mac?
And while we're at it, what are the particulars that always require that you change them? Are we talking changing from A4 (the European standard paper size) to the US letter size? Or some other kind of change(s)?
Jul 27 2022 12:17 AM
So I'm trying to make some printing default changes in Excel itself. When you have a document that you want to print directly from Excel, there are some printing options and I would like to set some of them as a default. For example that the pages are always printed in landscape and I also have multiple printers but always use just one for my excel documents so I would like to set the one that I use as a standard so I can save some time. To answer your other question, I'm using a PC.
Jul 27 2022 04:12 AM
Hmm....I'm quite sure you can set a given printer as the default printer--certainly I do so with my (Mac) laptop, which I carry from place to place, printer to printer--but things like landscape vs portrait mode seem to be very "spreadsheet specific" so I doubt you can make that some kind of all-inclusive setting. And once you've set it, if other users go to print this shared spreadsheet, they'd need to change it back to landscape....
I note you only site landscape mode as an example of the kind of thing you are wanting to do, implying that there are other idiosyncratic settings you seek to employ.
What does occur to me--if we're not talking of printing files that are shared with others or created by others, if what we're talking about is files you create and use yourself, printing them for others-- is that you could create template Excel documents that embody your default desired settings. Just create a template that itself is set to landscape, and any other defaults (big margin on the right, for example)....nothing else on the template but those, and then make that where you start when you go to create a New document.