The first thing to check is if you have printer drivers installed in Windows and, if you are using a networked printer, that the printer is online. This, of course, leads me to think that the problem Ali is facing is not related to Print Preview, but to some other condition occurring. In all instances the Page Layout tab of the ribbon is not visible when using Print Preview, but the page setup options are all accessible through the Page Setup dialog box. I tried all the above options from Print Preview with files in both native and compatibility mode and with different printer drivers. If you click Page Setup on the screen, Excel again displays the Page Setup dialog box and all the tools are available within it none are disabled. The print settings screen includes a quick-and-dirty print preview. There is, at this point, no ribbon displayed at all. Press Ctrl+P, Ctrl+F2, or display the File tab of the ribbon and click Print-it doesn't matter, all these display the print settings, which has a quick-and-dirty print preview. When using Excel 2010 or a later version you notice right away that the Print Preview is completely different than in Excel 2007. If you click the Page Setup tool, Excel displays the Page Setup dialog box which has all the tools available for use.
(You can also display Print Preview by pressing Ctrl+F2 or by pressing Ctrl+P and then clicking the Preview button.) Regardless of how you get to the Print Preview screen, the normal tabs of the ribbon are gone and only a Print Preview tab remains. When using Excel 2007, you can access Print Preview by clicking the Office button, then clicking Print | Print Preview.
I had a few other ExcelTips subscribers indicate that the condition occurs when Page Setup is accessed through Print Preview, but I couldn't get that to occur, either. In Excel 2007, Excel 2010, Excel 2013, Excel 2019, and Excel in Office 365 the Page Setup tools are always available. Try as I might, I cannot get this situation to occur on any of my test systems. He wonders why they would be disabled and what he can do to make them available. Ali notes that on his copy of Excel the tools in the Page Setup group of the Page Layout tab of the ribbon (Margins, Orientation, Print Area, etc.) are disabled.
0 kommentar(er)
