Business Automation and Software Blog

Excel Tips and Tricks: Customizing Ribbons

Posted by Robert Baran on Fri, Jul 06, 2012 @ 01:28 PM

Excel Tips and Tricks / Business Reporting Question: I find it tiresome switching between ribbons in Excel 2010 when I am creating reports. Is there a way of customizing a ribbon so that I can group all the frequently used functions together?

Answer: Yes, by creating a custom ribbon in Excel 2010. 

Why: To group all the frequently used functions together

Applies To MS Excel 2010:

1. Click on the file menu and select options.

Excel Tips and Tricks
2. Select ‘Customize Ribbon’ as given above.
3. Click on ‘New Tab’ as given above.
4. Rename the ribbon to Alchemex by clicking on the ‘Rename’ button. 
5. The screen shot below will be displayed.
Excel Tips and Tricks

6. Under ‘Popular Commands’ select the respective icons and click on the ‘Add’ button.

7.  To organize the custom ribbon in groups click on the ‘New Group’ command and repeat step 6.

8.  Repeat steps 6 & 7 until the new ribbon has been created. Thereafter click the ‘Ok’ button.

A new custom Alchemex Ribbon will appear on the Excel ribbon. The commonly used functions will thus be placed in one group. The user will be able to easily access those functions and eventually will save on time.

Excel Tips and Tricks

If you would like additional assistance with your business reporting needs, please contact us today for a complimentary consultation.

Contact PositiveVision ► ► for a Complimentary  Reporting Consultation

Topics: Business Reporting, Excel Tips and Tricks