Look Who it Was Random video

Excel - Customize Icons in Excel: RibbonX and More | Excel Tutorial - Episode 893

692 views · Published 5 January 2009 · 4:36 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Customize Icons in Excel: RibbonX and More.

Welcome back to the MrExcel netcast! In today's episode, we're going to be discussing how to customize icons in Excel. But before we dive into that, I have a special request for all of you. Our 10th anniversary is coming up this Friday and I would love to hear your feedback. I'm taking a quick survey and I want to know what we're doing right, what we're doing wrong, and any other ideas you have for the site. My marketing guru thinks we won't get more than 150 responses, but I know my community is better than that. So please take a few minutes to fill out the survey at MrExcel.com/survey.html before November 21st. Your input means a lot to me and it will prove my marketing guru wrong!

Now, let's get into today's topic. We all know that in Excel 2003, we could easily customize our toolbar by adding macros and even changing the icon. But in Excel 2007, things are a bit different. So the question is, how can we do the same thing in Excel 2007? Well, it's not as straightforward as it used to be. When we go to customize the Quick Access Toolbar, we do have the option to add macros, but the ability to change the icon has been removed. Microsoft expects us to use Ribbon X, which allows us to create our own custom tabs and icons. However, this can be quite challenging for those who are not familiar with coding.

If you're interested in learning how to use Ribbon X, I highly recommend the book "Ribbon X: Customizing the Office 2007 Ribbon" by Ken Puls. This book, written by two Excel MVPs, provides step-by-step instructions and examples on how to create your own custom tabs and icons in Excel 2007. It's a great resource for those who want to take their Excel customization to the next level. However, for those who are not comfortable with coding, the old icon editor in Excel 2003 was much easier to use.

In conclusion, while Excel 2007 may have removed the ability to easily customize icons, it has also given us more power through Ribbon X. So if you're up for the challenge, I highly recommend checking out the book "Ribbon X: Customizing the Office 2007 Ribbon". And as always, thank you for tuning in to the MrExcel netcast. We'll see you next time for more Excel tips and tricks!

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/


Eric asks how to customize icons for his macros on the Excel 2007 Quick Access Toolbar. In Episode 893, I will take a look at this feature in Excel 2003 and the limited options available in Excel 2007.

Table of Contents:
(00:00) Introduction and special request
(00:28) Importance of survey and current response rate
(00:57) Instructions for taking the survey
(01:19) Today's topic: custom toolbar in Excel 2007
(02:18) Frustration with changing tool tip and icon in Excel 2007
(03:06) Solution: using Ribbon X and recommended book
(03:54) 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 

This video answers these common search terms:
10th Anniversary
Custom toolbar
Feedback
Icon editor
Macros
Office 2007 Ribbon customization
Quick Access toolbar
Ribbon X
Survey
Where Is It Wednesday


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

More from this channel