by Allen Wyatt
(last updated January 25, 2014)
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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Click on a cell and you expect the single cell to be selected. If you instead get a group of cells, it can be frustrating to ...Discover More
As the limits on what you can store in Excel have increased, so has the need to consider how to make your workbooks and ...Discover More
Excel stores dates and times internally using what is called a serial number. This tip explains how that serial number is ...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.