

Deploying a Customized Ribbon and Quick Access Toolbar in. The pull-down menu is where you can quickly add some buttons or choose More Commands to choose from all the possibilities. Restart the server to update the settings, or run the gpupdate/force command. If Microsoft was serious about listening to customers, their new look Office would have included fixes for these from the beginning, not the vague promise as an afterthought. Microsoft says they are “planning updates to these controls” with no timeframe or specifics. After recent updates, the ribbon in Microsoft Excel can take up to 1/3 of the available screen space. The compulsory and self-serving AutoSave switch and Save button don’t help the crowded title bar, yet they are still there with no way to get rid of either.

Apparently Microsoft has forgotten that, when released in Office 2007, one reason for the ribbon was to stop ‘menu creep’ intruding on the document/editing space. The upside is a QAT below the ribbon has a totally empty row available for buttons.ĭownside is that more screen space is used by Office ribbon etc. That’s become a space problem of Microsoft’s own making with the QAT crowded out. Toolbar is missing in Excel 235,734 views 2.2K Dislike Share Save Be a Fixxer 3.77K subscribers This video will help you to get back the Toolbar / Ribbon bar in Microsoft Excel.

In recent years, the top title bar has become very crowded with buttons, Search Box and a pull-down list under the document name. If Quick Access is not working you may need to reset it using the Windows Registry: Run regedit to open the Registry Editor. You might also consider distributing your file as an add-in, rather than having users put it in their XLSTART folder. It’s easy to see why Microsoft has switched to a QAT under the ribbon. You might also check the 'At startup, open all files in' (under Excel Options->Advanced->General), although I believe XLSTART is included by default.
