Customising Microsoft Excel 2010
When Microsoft Excel 2007 was first released, quite a few new users struggled to come to terms together with the new Ribbon style of navigation. A single aspect which baffled individuals the mist was basically tips on how to open and save documents. There appeared to be no method to carry out these basic acts as there was no longer a ‘File’ menu option. Unbeknown to quite a few, these possibilities have been now to all intents and purposes hidden way behind the so-called ‘Office Button’. The issue was that several 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 within the most up-to-date 2010 version of Excel, by replacing the button together with the familiar ‘File’ menu. Seems like Microsoft listened this time! In this post we shall look at the numerous options for customising Excel 2010 so that you can get the most beneficial out on the software.
The Quick Access Toolbar
The Quick Access Toolbar would be the small menu that is situated by default above the primary Ribbon menu. When the software is first loaded it only functions three buttons: Save, Undo and Redo. On the other hand, the array of tools is usually extremely simply be extended by clicking the smaller black drop-down arrow which is situated in the proper on the menu. Selecting this reveals a brief list of further tools which is usually added towards the toolbar by clicking alongside, which has the impact of ‘ticking’ the choice and adding it for the toolbar. Further tools may be added by clicking ‘More Commands’ in the bottom from the menu and picking from a large range of tool possibilities. Finally, the position of your Quick Access Toolbar itself is usually changed by clicking the menu and picking ‘Show Below the Ribbon’. My individual view is that this isn’t a particularly great position for it as it requires up added area. In its default position It shares the same space because the document name across the prime and represents a much more logical spot 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 smaller grey ‘pins’ which when clicked have the impact 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 from 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 superior as you open additional documents.
Last but not least, the Ribbon itself can be customised by adding tool buttons which you use frequently. To do this, first click the File menu and select Possibilities. Now select ‘Customise Ribbon’ and then click ‘New Group’. It is necessary to create a new group to be able to added buttons for 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 can 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 with the facility to simply customise the Ribbon to suit your private requirements, Excel 2010 would appear to be the ideal version yet offered by Microsoft.