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?
My Excel Profession Plus 2019 only does this if a 'print area' is set.
If one is not set it goes straight to the preview.
Re the 'Print of Huge Data' query from Shahab, try adjusting the page settings;
Page Layout > Print Titles. On the Page Tab adjust the "Fit to" settings...
Bob Gollery commented
Fire the folks that decided to "recreate the wheel" - can't print the entire spreadsheet, only the top row; can't find the scroll bar; can't tell if the spreadsheet is outside the printable area; where is print-preview???!!! Really - I need to print this document ......
anyone knows the solution of Print of huge data please see the attached Photos.
Still no different a week later. Sometimes it will show the actual print preview, and sometimes it takes you to the Print Preview button. Ctrl + F2 does still take me directly to the print preview image, though.
For me the print preview sometimes works, sometimes not, just as everyone is reporting. What seems to always work is using Ctrl+F2. That always seems to deliver the print preview screen directly and not just the button to the print preview screen.
I miss the days when Windows worked and was worth something.
there is no rhyme or reason or size limitation that i can find that controls this weirdness. sometimes the print image shows up automatically...sometimes it doesn't ....pretty sure it's a glitch that needs fixing because it drives me crazy !
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.