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.
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.
If you would like additional assistance with your business reporting needs, please contact us today for a complimentary consultation.