Written by Allen Wyatt (last updated August 21, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
Excel provides you with quite a bit of flexibility in how your toolbars appear. You can change the appearance of your toolbar buttons so they accurately reflect how you want Excel to appear. For instance, you may have added a custom macro to a toolbar, and you want to change it so that a graphic appears on the toolbar button instead of the macro name. Follow these steps:
Figure 1. The Toolbars tab of the Customize dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2725) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Toolbars allow you to access common tasks quickly and easily. Excel provides a wide variety of toolbars, and you can even ...
Discover MoreNot only does Excel allow you to customize your toolbars, but you can also move commands from the toolbars to your menus. ...
Discover MoreWouldn't it be great to have a workbook accessible with just a single button click? It's possible if you follow the steps ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-08-23 20:33:27
Allen
Richard,
No, it doesn't work in Office 2019. As it says at the end of the tip, "This tip (2725) applies to Microsoft Excel 97, 2000, 2002, and 2003."
In fact, this whole site is for older versions of Excel. If you want tips for the newer versions, see the notice at the top-right of every page on this site.
-Allen
2021-08-23 18:46:02
Richard Blunt
Does this work in Office 2019? I thought they discontinued it several years ago... :( I tried these steps hoping that maybe they brought it back but none of this worked for me. This looks like the way I used to do it in the old days :)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments