Look Who it Was Random video

Excel - How To Add Commands To Excel Ribbon - Episode 1255

670 views · Published 29 September 2010 · 2:43 · Indexed 6 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Customizing the Ribbon in Excel.

Welcome back to the MrExcel podcast. In this episode, we will be wrapping up Chapter 2 of Excel 2010 by discussing the exciting topic of customizing the Ribbon. This feature was unfortunately removed in Excel 2007, but thankfully, it has made a comeback in Excel 2010. As someone who spends a lot of time on the Home and Data tabs, I have always wished for the ability to combine certain features from both tabs. And now, with the ability to customize the Ribbon, my wish has finally come true.

To begin customizing the Ribbon, simply right-click on it and select "Customize the Ribbon". This will open up a new window where you can make changes to the Ribbon. First, we will add a new tab and rename it to "MrExcel". Then, we can move this tab to the left, placing it next to the Home tab. Now, we can start adding the features we want from different tabs. For example, we can add the Clipboard, Alignment, and Number features from the Home tab, the Pivot Table command from the Insert tab, and the Sort & Filter, Data Tools, and Outline features from the Data tab.

Once we have added all the desired features, we can remove any unnecessary groups and click "OK" to save our changes. And just like that, we have our very own customized MrExcel tab with all the features we use most frequently. The best part is, we can export this customization and share it with our co-workers, making it easier for everyone to access the same custom tab. While it may not be as powerful as the customization options in Excel 2003, it is still a great feature to have in Excel 2010.

Thank you for tuning in to this episode of the MrExcel podcast. I hope you found this tutorial on Ribbon customization helpful. Don't forget to check out our sponsor, MrExcel.com, for all your Excel needs. And be sure to join us next time for another informative netcast from MrExcel. See you soon!

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) Excel Ribbon Customization
(00:31) Combine favorites from Home and Data tab
(00:45) Customize Ribbon
(00:59) Create new tab in ribbon
(01:22) Add icons to your new ribbon tab
(02:14) Exporting Ribbon Customization for co-workers
(02:25) Clicking Like really helps the algorithm

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


This video answers these common search terms:
how to add new tab to ribbon in excel
how to add commands to excel ribbon
how to add tab to ribbon in excel
how to add a ribbon on excel
excel how to add a ribbon
how to add a macro button to excel ribbon
how to add macro to excel ribbon

One of the great things to return to Excel 2010 is the ability to customize the ribbon - without knowing XML and without being a programmer! Customize the Ribbon in Excel 2010 to make the interface more efficient for your needs. Episode #1255 and Chapter 2 of "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen show you how.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

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

More from this channel