Dialog box notifying user that Printing will generate a large number of pages
When you click Print, Excel should look at the number of pages that will be generated and give you a dialog box noting that you should check your page setup because if you continue you will generate X number of pages.
This is an issue I've had with Excel for decades, not years, decades! By now Excel should be able to review your document page breaks and identify that your spreadsheet for example is 26 columns wide and 26 rows long, could be printed on one sheet. It should then give you a dialog box alerting you to check your print area setup as you will print (example), 50 pages if you click Print again.
Again, this is something that has bugged me for decades to the point where I (and probably millions of other people), have wasted billions of sheets of paper reprinting a multi-page spreadsheet when it could have easily formatted onto one sheet.
Just happened again today. Wasted 20 sheets of paper when I hit Print on a spreadsheet emailed to me from a colleague. I finally broke down and took the time to write the Excel Suggestion Box.
Make it happen team!!!
Kenneth Barber commented
I think that this was more of an issue in Microsoft Office 2003, which had a print button in one of the toolbars. Clicking on it would print everything. No warnings or anything.
To my knowledge, in the newer versions of Microsoft Office, you will always see a print preview when you go to print, so if you click Print without looking at what will be printed, that is your fault.
randy R commented
Best idea ever!