Auto display print preview
I added a "Print preview and print" button to my button bar. When I click it, it takes me to the same page as File > Print, which is fine. In the area where the print preview should show, all I see is a button "print preview". It doesn't show the preview unless I click the button. Why doesn't it automatically show print preview like it did in Office 2010?
What a load of rubbish from Chris
Automatically previewing my work should not depend on the size of the file.
This icon (Show Print Preview) is just a waste of time. Not only do I have to find it way down the page - then click it, I also have to scroll more to see my preview (and there is something broken with that scroll too). Who thought this is a good idea?? What kind of QA is Microsoft doing? What annoys me e is that these things happen with an update - which is supposed to improve things, not make them worse. Why take something that is efficient and effective and render it useless?
Perhaps selecting the "Print Area" will help.
I went and researched this Print Preview issue. I started testing in Excel 2016 (O365 Home).
Here is the answer. If you file becomes a certain size, I can't tell you exactly what that size is, you will get the extra Print Preview icon. I have a file with 985001 rows of data. The file was 17MB.
I deleted all but 10 rows. Still got the extra PP screen. Clicked Save and then PP worked as it should. I tested a few times and this is definitely what is causing it. I even tested saving the file to OneDrive vs saving to my local computer. It didn't matter. Same results.
So the answer is when you Excel file become a certain size you have to click PP twice. It doesn't have anything to do with the Quick Access toolbar either.