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.
In fact, to make your reporting easier, Alchemex has created a customized BI ribbon which you can download for FREE here and follow the easy instructions to install.
Why: To group all the frequently used functions together.
Applies To MS Excel 2010:
1. Click on the file menu and select options. The screen shot below will be displayed.
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.
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.