• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Customize the Ribbon in Excel

You are here: Home / Excel VBA / Customize the Ribbon in Excel
Customize the Ribbon in Excel
June 18, 2014 by Philip Treacy

You can customize the Ribbon in Excel so that you add your own tabs and icons to run commonly used tasks and tools, or run your macros.

NOTE : This applies to Excel 2010 and 2013 only. Modifying the Ribbon in Excel 2007 is a different process which I will cover in another post.

Just follow the steps below, it should only take about 5 minutes.

You can also modify the Quick Access Toolbar to show your own icons for macros and commands.

Step 1

Right click your mouse anywhere on the QAT or the Ribbon, and from the menu that appears, click on Customize the Ribbon...

Right Click Menu to Customize the Ribbon

Step 2

The next window that appears has a list of commands on the left had side of the main pane, from this you can choose commands to add to the Ribbon.

Excel Options for the Ribbon

You can uncheck the default tabs listed on the right hand side, but you can't remove them. You can open up the tabs and remove items in them though. For example, if you double click on Home to open it, you see the groups in the Home tab like Clipboard, Font, Alignment etc. These items can be removed.

Step 3

Click the New Tab button to create a new tab. This will be added to the right hand side of the pane with the default name New tab (Custom), and a new group inside it named New Group (Custom).

Create a new tab

Step 4

Select the new tab and then you can either right click and choose Rename, or click on the Rename button.

Rename the new tab

Enter a new name for the tab and click OK. I'm calling mine PGT.

Rename the new tab

Step 5

Select the new group and rename it as we just did with the tab. When you click on Rename you'll see this window.

Renaming the new group

Enter the new group name in the Display name box. Choosing an icon has no effect. My new group is called PGT's Macros.

Step 6

OK so I've renamed my tab and group, now I need to add some commands or macros to it.

If you leave the Choose commands from drop-down as Popular Commands then you can add regular Excel commands, but I want to add some awesomely cool macros, so I'm choosing Macros from the drop-down.

This is what you want to choose if you want to add macros from your Personal.xlsb.

Select macros as source

Step 7

From the list of macros that are now displayed, click on the macro you want to add, then click on the Add>> button. I've added two macros.

Choose the macros you want to add

Step 8

As with the new tab and group, we now need to rename our macros to something more meaningful. Right click the macro and choose Rename.

Rename the macros

Step 9

You should now be looking at a large list of icons. Choose the icon you want for your macro. I'm going with a bright green square (I like green).

In the Display name box, enter a name for the macro, this also becomes the tool tip you see when you hover your mouse over the icon.

Repeat this process for each macro you added.

Choose new icons and names for the macros

Step 10

Once you have renamed all your macros you should have something like this.

Changes to macros finished

Step 11

You can adjust the position of the tab, group(s) and items in each group by first selecting the tab, group or item, and clicking the Up/Down arrows.

how to reorder items

Step 10

When you are finished with your changes, click OK to close this window and you'll see that you now have a new tab on the Ribbon with your new group and icons for the macros.

The Customized Ribbon

Customize the Ribbon in Excel

More Excel VBA Posts

automating and emailing pivot table reports

Automating and Emailing Pivot Table Reports

Automate the creation and distribution of pivot table reports with some VBA. Send reports to multiple email recipients using Outlook.
Checking values in range objects with vba

Checking Values in Range Objects With VBA

Use built in tools or your own code to examine the values contained within Range objects in VBA. Sample code to download.
Static variables in VBA

Static Variables in VBA

Variables normally cease to exist once your Sub or Function has ended. But Static Variables allow you to preserve values after your code has finished.
save chart as image

Save Chart as Image

List all the charts in your workbook then select the ones you want to save as either PNG or JPG. Sample workbook and code to download
Clearing Downstream Dependent Data Validation Lists

Clear Downstream Dependent Data Validation Lists

Change one of your data validation lists and clear the values in the other data validation lists dependent on your first choice.
Excel Status Bar

Excel Status Bar

Use the Excel Status Bar to send messages to your users and to show a progress bar for your VBA code
Progress Bar for Excel VBA

Excel Progress Bar for VBA

Create your own progress bar for VBA in Excel. Use it to show that your code is still running, and how long before it finishes.
error handling in vba

Error Handling in VBA

Understand how Excel VBA generates errors, how to control what Excel does when an error occurs, and how to write your own error handling routines.
Finding File Metadata Using FileSystemObject

Finding File Meta Data Using FileSystemObject

Find file meta data like the creation date, last modified date and file size using Windows FileSystemObject in Excel VBA
Automatically Add Items to Data Validation List

Automatically Add Items to Data Validation List

Automatically Add Items to Data Validation List by typing in the new data. Then sort the source list for bonus points

More Excel VBA Posts

Display All Matches from Search in Userform ListBox

Display All Matches from Search in Userform ListBox

Search a range for all partial and full matches of a string, and display matching records (entire rows) in a userform listbox. Sample code and userform.
animating excel charts

Animating Excel Charts

Use animation correctly to enhance the story your data is telling. Don't animate your chart just for some eye candy. Sample code and workbook to download.
dynamic data validation lists in userforms

Dynamic Data Validation Lists in Userforms

Data validation lists using the same source that are dynamically modified to prevent the same choice being made in each list.
show report filter pages for power pivot pivottables

Show Report Filter Pages for Power Pivot PivotTables

PivotTables created from Power Pivot can't use the 'Show Report Filter Pages' option. But this piece of VBA allows you to do just that.
charting real time data in excel

Charting Real Time Data in Excel

Receive data in real time and chart the data as it arrives. Can be used to chart things like stock prices or sensor readings. Sample code and workbook
select multiple items from drop down data validation list

Select Multiple Items from Drop Down (Data Validation) List

Choose multiple items from a data validation (drop down) list and store them all in the same cell. Sample workbook with working VBA.
Excel Calendar (Date Picker) to Use in Worksheets and Userforms

Multi-Language Excel Calendar (Date Picker) for Worksheets and Userforms

Easy to use, highly customizable and multi-language. This date picker is implemented as a userform that is simple to integrate into your workbook.
automating and emailing pivot table reports

Automating and Emailing Pivot Table Reports

Automate the creation and distribution of pivot table reports with some VBA. Send reports to multiple email recipients using Outlook.
search for data with userform

Searching for Data With a User Form

Search a list of records (like a table) using a user form, and then populate the fields of the search form when the record is found.
Checking values in range objects with vba

Checking Values in Range Objects With VBA

Use built in tools or your own code to examine the values contained within Range objects in VBA. Sample code to download.
Category: Excel VBATag: Excel VBA
Previous Post:Customize the QAT (Quick Access Toolbar) in ExcelCustomize the QAT (Quick Access Toolbar) in Excel
Next Post:Protect and Unprotect All Sheets in a WorkbookProtect and Unprotect All Sheets in a Workbook

Reader Interactions

Comments

  1. Stefano Gatto

    April 23, 2020 at 4:03 am

    Hello – thank you for explaining here how to customize the ribbon to add access to new functions which are implemented in personal macros. But what happens if those macros are not open in Excel? Back with Excel 2000/2003, I made a macro which was adding a menu in Excel whenever you opened it, and was removing it whenever you were closing it. Of course it worked under the form of an addin too. The advantage was that when you uninstalled the addin those extra menuitems disappeared. So in conclusion it would be nice to have the manual steps you demoed here, be programmed in the AutoOpen of my workbook implementing the extra functionality (addin). Is this possible?

    Reply
    • Philip Treacy

      April 23, 2020 at 3:20 pm

      Hi Stefano,

      Yes it’s possible to do this. You’re the 2nd person today to ask about custom Ribbon UI!

      Microsoft – Customize the ribbon

      I’ll have to write a post about it.

      Regards

      Phil

      Reply
  2. Bill Staggs

    December 14, 2019 at 2:12 am

    Mynda & Philip,
    Your Blogs are always so easy to follow.
    Thanks for your generosity

    Reply
    • Philip Treacy

      December 14, 2019 at 8:59 am

      You’re welcome Bill, glad to help.

      Regards

      Phil

      Reply
  3. Bob

    June 11, 2015 at 1:18 am

    Customization of your ribbon can be a significant productivity boost, but there is a downside.

    For example: I had put many icons on the quick access tool bar to improve productivity on my workstation. That was all well and good until the day I went to take an MOS certification test. I found myself in front of a tiny 15″ CRT monitor, and standard Excel ribbon. Hmmmm. I spent a good deal of test time searching the ribbon for icons that I had become accustomed to just grabbing from the quick access tool bar. It was funny afterward, but not in the moment.

    My only point is – if you’re prepping for an MOS test you might want to reset your workstation to the standard ribbon and turn off, or temporarily remove, your quick access tool bar icons.

    Reply
    • Philip Treacy

      June 11, 2015 at 8:49 am

      Good point Bob

      Reply
  4. MF

    July 3, 2014 at 5:39 pm

    Do you really have the macros that can “Fix everything” or “Increase my salary”??? heeheee… Pls share if it exists. 🙂

    Reply
    • Philip Treacy

      July 3, 2014 at 6:31 pm

      🙂

      I’ll email them right over

      Reply
  5. Arvind

    July 2, 2014 at 6:49 pm

    How we can add location in our excel file Ribbon.

    Reply
    • Philip Treacy

      July 2, 2014 at 9:40 pm

      Hi Arvind,

      I’m not sure what you mean by adding a location – can you explain a bit more please?

      Regards

      Phil

      Reply
  6. Joyce

    June 20, 2014 at 2:49 am

    Really wish we had Excel 2010 at work. At least I can use this tip at home. Thank you!

    Reply
    • Philip Treacy

      June 20, 2014 at 12:05 pm

      You’re welcome

      Reply
  7. Jef

    June 18, 2014 at 4:03 pm

    Great. Works fine. I had done a lot of customization to my Excel menu. Thanks for sharing.

    Reply
    • Philip Treacy

      June 18, 2014 at 4:27 pm

      Thanks Jef.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Shopping Cart

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x