by Allen Wyatt
(last updated October 4, 2017)
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 Titles, etc.) are disabled. He wonders why would they be disabled and what he can do to make them available.
Try as I might, I cannot get this situation to occur on any of my test systems. In Excel 2007, Excel 2010, and Excel 2013 the Page Setup tools are always available. 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.
When using Excel 2007, you can access Print Preview by clicking the Office button, then clicking Print | Print Preview. (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. (See Figure 1.)
Figure 1. The Print Preview tab 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.
When using Excel 2010 or Excel 2013 you notice right away that the Print Preview is completely different than in Excel 2007. 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. There is, at this point, no ribbon displayed at all. (See Figure 2.)
Figure 2. The print settings screen includes a quick-and-dirty print preview.
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.
I tried all the above options from Print Preview with files in both native and compatibility mode and with different printer drivers. 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.
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. The first thing to check is if the problem crops up with all workbooks or just with a single one. If it is the latter, then it could be that the workbook is corrupted in some way. (Try the problem workbook on a different system, just to make sure.)
It could also be that there is an add-in or a macro in the workbook that is causing the problem. You can figure out if this is the case by disabling all your add-ins and saving the workbook in XLSX format (instead of XLSM) so that the macros are stripped from it. Open up the newly saved workbook and see if the problem still exists.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12917) applies to Microsoft Excel 2007, 2010, and 2013.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Referring to cells is typically done using a letter and a number, which represent the column and row. That's not the only ...Discover More
Does your worksheet or workbook not always recalculate like you expect? If so, then some of the ideas in this tip may ...Discover More
Excel has several features that cannot be customized. The font size in the drop-down lists is one of them. If you need ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.