Look Who it Was Random video

Excel - Customize Your Excel Toolbars: Edit Icons and Add Webpage Shortcuts - Episode 424

380 views · Published 24 September 2009 · 2:25 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Customizing Toolbars in Excel 2003 and Earlier.

Welcome back to another episode of the MrExcel netcast! In this video, we will be discussing how to customize your toolbars in Excel ‘97 through Excel 2003. By simply right-clicking on a toolbar and selecting Customize, we can access the Customize dialogue and make various changes to our toolbars.

One useful trick is the ability to change the button image on a toolbar. If you don't like the default image, you can right-click on it and choose to change the button image. You can even edit the image pixel-by-pixel to create a custom icon. It may be tedious, but it's a great way to personalize your toolbars.

But that's not all! Did you know that you can also add brand new icons to your toolbar that initially do nothing? By right-clicking on the Macros item and selecting the "nothing" icon, you can then change the button image and assign a hyperlink to it. This means that you can create a shortcut to your favorite webpage, such as MrExcel, and access it directly from Excel with just one click.

And for a fun little prank, be sure to tune in on Friday for some wild tricks you can do with your toolbar icons. Imagine the look on your manager's face when they click on an innocent-looking icon and it takes them to a silly webpage. Don't worry, we won't tell them it was your doing. Thanks for watching and don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time on the MrExcel netcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to customizing toolbars in Excel
(00:19) Accessing the Customize dialogue
(00:34) Changing button images on toolbars
(00:44) Editing button images pixel-by-pixel
(00:54) Adding new icons to toolbars
(01:07) Assigning hyperlinks to toolbar icons
(01:43) Opening web pages from Excel using toolbar icons
(01:53) More tricks for customizing toolbar icons
(02:08) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152636/



More tricks for your Excel toolbars, including how to edit the icons or how to add an icon to the toolbar that opens a particular webpage, perhaps www.MrExcel.com! Episode 424 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel