How to Customise the Microsoft Excel Ribbon Menu

Customising Microsoft Excel 2010
When Microsoft Excel 2007 was 1st released, many new users struggled to come to terms using the new Ribbon style of navigation. One aspect which baffled people the mist was basically the way to open and save documents. There appeared to be no technique to carry out these uncomplicated acts as there was no longer a ‘File’ menu choice. Unbeknown to quite a few, these selections have been now to all intents and purposes hidden way behind the so-called ‘Office Button’. The concern was that lots of people today thought that the Office Button as just the Microsoft logo and so didn’t even feel to click it! This concern has been addressed by Microsoft in the most up-to-date 2010 version of Excel, by replacing the button with the familiar ‘File’ menu. Appears like Microsoft listened this time! In this report we shall look in the different possibilities for customising Excel 2010 as a way to get the most effective out from the computer software.

The Quick Access Toolbar
The Quick Access Toolbar will be the little menu which can be situated by default above the key Ribbon menu. When the computer software is first loaded it only capabilities three buttons: Save, Undo and Redo. Nonetheless, the range of tools might be pretty conveniently be extended by clicking the smaller black drop-down arrow which is situated in the ideal with the menu. Selecting this reveals a short list of added tools which may be added to the toolbar by clicking alongside, which has the impact of ‘ticking’ the selection and adding it towards the toolbar. Additional tools can be added by clicking ‘More Commands’ in the bottom of the menu and choosing from a big selection of tool options. Lastly, the position of the Quick Access Toolbar itself may be changed by clicking the menu and selecting ‘Show Beneath the Ribbon’. My personal view is the fact that this isn’t a especially fantastic position for it as it takes up further space. In its default position It shares the identical space because the document name across the top rated and represents a far more logical place for it to become.

The Recent Documents & Folders List
The recent documents list was around in the 2007 version of Excel, but the current folders facility is new to Excel 2010. They both feature little grey ‘pins’ which when clicked have the effect of ‘pinning’ your documents and folders onto the brief list of recent files. This is a quite useful function and stops your most used documents from dropping off the bottom with the list. It doesn’t actually pin them to the exact same spot and you will find that they will move around the list, but at least they won’t be lost for good as you open far more documents.

The Ribbon
Last but not least, the Ribbon itself could be customised by adding tool buttons which you use frequently. To do this, 1st click the File menu and select Options. Now select ‘Customise Ribbon’ and then click ‘New Group’. It is necessary to create a new group so that you can additional buttons towards the Ribbon toolbar. Tool buttons can now be added to this custom group by choosing from the menu on the left and then clicking ‘Add’. Finally the custom group might be given a user-friendly name by clicking the ‘Rename’ button.

Once we’ve become familiar using the new Ribbon style of navigation in Excel 2010, most customers do seem to prefer the system. Coupled using the facility to simply customise the Ribbon to suit your personal requirements, Excel 2010 would appear to become the best version yet offered by Microsoft.