This video tutorial shows how to remove any custom toolbars from the Ribbon, by using a mouse shortcut. It will turn up again, whether you want it or not, the next time you open that workbook. When the warning message appears, click Yes, to confirm that you want to delete the custom toolbar.Īnd don’t worry - you’re not deleting the toolbar from the workbook.Right-click on one of the custom toolbar’s commands.To delete a custom toolbar from the Ribbon: The good news is that you can delete the custom toolbars from the Ribbon, with an easy mouse shortcut. Nope, they hang around, uninvited, cluttering up the place. From the right hand side youll then see an area called 'Customize the Ribbon'. From the dialogue box, click on Customize Ribbon on the left side. Unfortunately, those custom toolbars don’t automatically disappear when you close the workbook to which they’re attached. In the section labelled 'Top options for working with Excel' check the box for 'Show Developer tab in the Ribbon': In Excel 2010 to 2016 click the File menu then select Options. Here’s just a small section of my Add-Ins tab, after opening a client’s workbook. Things can get pretty messy, especially if those custom toolbars had more than a few buttons. If you open an Excel 2003 workbook that has an attached custom toolbar, that custom toolbar’s tools will appear on the Add-Ins tab in the Ribbon. In the Excel Options window, there is a button on the bottom that says Import/Export. If you would like to transfer your customized buttons and tabs to another computer or user, you can do so easily. It has an Add-Ins tab, where custom toolbars and menu commands will appear. Then choose Add to Quick Access Toolbar (the first option in the menu shown above). The Ribbon was introduced in Excel 2007, to replace the Excel toolbars. This is the Customize dialog box in Excel 2003, where you could attach a toolbar. Here’s how you can delete custom toolbar from Excel Ribbon, if you don’t want to see it. I didn’t use that feature, but occasionally I receive a workbook where someone has attached a toolbar.

In Excel 2003, you could create a custom toolbar, and attach it to a specific workbook.

Add toolbar to excel 2010