Creating a custom tab

By Neil Shorney, Director, Naturally Sales Ltd.

Many people are familiar with the quick-access toolbar for organising a few frequently-used buttons on your Excel application. Did you know that in Excel 2010, you can create a fully-functional custom ribbon tab to organise your most frequently-used functions into logical groupings for easy access?

To do this, click File then Options then Customize Ribbon followed by the item you'd like to create. First choose New Tab and to create custom groupings within the new tab, choose New Group. There is no limit to the number of groupings you can create.