by Allen Wyatt
(last updated January 4, 2020)
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. He wonders why they would 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, Excel 2013, Excel 2019, and Excel in Office 365 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 a later version 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 you have printer drivers installed in Windows and, if you are using a networked printer, that the printer is online. It could be that if you don't have a printer available to Excel that the program is disabling those options because setting them would have no meaning.
Another 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, 2013, 2016, 2019, and Excel in Office 365.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Need to understand who is using a particular workbook? There are a number of ways you can find out, as discussed in this tip.Discover More
When you create a shared workbook, you run the risk of losing some of the data in that workbook. Here's a discussion ...Discover More
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
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.