- #Customize the ribbon greyed out excel 2013 how to
- #Customize the ribbon greyed out excel 2013 drivers
Under the Home tab you can see the groups, Clipboard, Font, Paragraph, Styles and Editing. On the right-side is a list of the current tabs and the groups available on each row. It’s far more likely they’ll use the keyboard shortcuts (eg Ctrl + C, Ctrl + X or Ctrl + V).Ĭhanging that is easy, right-click on the ribbon and choose ‘Customize the Ribbon …’ Most people don’t use the ribbon to copy, cut or paste except in special cases. Microsoft’s analysis over the years confirms that, but does it mean it should be in the prime, left position? Microsoft puts the most commonly used features or the most important (to Microsoft) in that left position.Ĭopy, Cut and Paste are certainly the most commonly used functions in Word. The left side is the most prominent place for any ribbon button or section. The very left of the Home tab has the Paste and other clipboard related features. The QAT is certainly easier to change but a single line of buttons isn’t always enough. Even so Microsoft’s usual advice is to change the Quick Access Toolbar.
#Customize the ribbon greyed out excel 2013 how to
Then how to change it to suit you.Ĭhanging the ribbon was difficult in Office 2007 but improved in later versions. In this article, we’ll show you an example of how the ribbon is designed to suit absolute Office novices first and also with Microsoft’s marketing agenda in mind.
You’re not stuck with the ribbon Microsoft gives you, make it work better for you. Open up the newly saved workbook and see if the problem still exists.Love or loath it, the ribbon in Microsoft Office is here to stay. 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. It could also be that there is an add-in or a macro in the workbook that is causing the problem. (Try the problem workbook on a different system, just to make sure.) If it is the latter, then it could be that the workbook is corrupted in some way. 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.Īnother thing to check is if the problem crops up with all workbooks or just with a single one.
#Customize the ribbon greyed out excel 2013 drivers
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.