Tips on how to Personalise the Ribbon Menu in Excel 2007 / 2010

Customising Microsoft Excel 2010

When Microsoft Excel 2007 was first released, quite a few new customers struggled to come to terms together with the new Ribbon style of navigation. A single aspect which baffled individuals the mist was merely the best way to open and save documents. There appeared to be no strategy to carry out these simple acts as there was no longer a ‘File’ menu option. Unbeknown to quite a few, these solutions have been now to all intents and purposes hidden way behind the so-called ‘Office Button’. The problem was that numerous people today thought that the Office Button as just the Microsoft logo and so didn’t even assume to click it! This concern has been addressed by Microsoft in the latest 2010 version of Excel, by replacing the button using the familiar ‘File’ menu. Seems like Microsoft listened this time! Within this short article we shall appear in the several choices for customising Excel 2010 in order to get the very best out from the computer software.

The Quick Access Toolbar

The Quick Access Toolbar will be the small menu which can be situated by default above the key Ribbon menu. When the application is initially loaded it only capabilities three buttons: Save, Undo and Redo. Nonetheless, the selection of tools is often quite effortlessly be extended by clicking the tiny black drop-down arrow that is situated in the proper from the menu. Selecting this reveals a quick list of further tools which could be added to the toolbar by clicking alongside, which has the impact of ‘ticking’ the selection and adding it to the toolbar. Additional tools can be added by clicking ‘More Commands’ at the bottom of your menu and selecting from a sizable selection of tool solutions. Finally, the position of your Quick Access Toolbar itself could be changed by clicking the menu and picking ‘Show Under the Ribbon’. My individual view is that this isn’t a especially fantastic position for it since it requires up added space. In its default position It shares exactly the same space because the document name across the leading and represents a additional logical place for it to be.

The Recent Documents & Folders List

The recent documents list was around inside the 2007 version of Excel, but the recent folders facility is new to Excel 2010. They both feature compact grey ‘pins’ which when clicked have the impact of ‘pinning’ your documents and folders onto the short list of current files. This is a very useful function and stops your most used documents from dropping off the bottom with the list. It doesn’t actually pin them for the identical spot and you will find that they will move around the list, but at least they won’t be lost for excellent as you open extra documents.

The Ribbon

Last but not least, the Ribbon itself is usually customised by adding tool buttons which you use frequently. To do this, initially click the File menu and select Choices. 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’. Ultimately the custom group is usually given a user-friendly name by clicking the ‘Rename’ button.

Summary

Once we’ve become familiar with all the new Ribbon style of navigation in Excel 2010, most users do seem to prefer the system. Coupled together with the facility to quickly customise the Ribbon to suit your individual requirements, Excel 2010 would appear to become the ideal version yet offered by Microsoft.

For information about Stamford Excel courses visit the website at www.paulbrowntraining.org