Using Toolbars In Microsoft Excel 2007

Computers Add comments

The Quick Access Toolbarbr /
br /
The a href=http://www.trainingcompany.com target=_blankMicrosoft Excel/a Quick Access Toolbar is normally displayed in the top left of your screen next to the Office button. It has a similar format to the toolbars found in previous versions of Microsoft Excel. By default it contains just three items: saving the active workbook, undoing commands and redoing commands.br /
br /
Next to these buttons is a drop-down menu which enables you to customise the Quick Access Toolbar by determining which commands are visible and which commands are hidden. Each of the options in the drop-down menus is a switch. If the option is currently active, when you choose it, it disappears from the Quick Access Toolbar. br /
br /
Another way of customising the quick access toolbar is to add your favourite options from the various tabs of the Microsoft Excel ribbon. To add an option simply right-click on it and, in the context menu which appears, choose Add To Quick Access Toolbar. The option will then appear on the Quick Access Toolbar and can be used in the normal way.br /
br /
If you find yourself using the Quick Access Toolbar frequently, you may find it convenient to display it below the ribbon simply choose Show Below the Ribbon from the Customise Quick Access Toolbar drop-down menu and of course you always have the option of minimising the ribbon by double clicking on the name of any ribbon tab.br /
br /
The Mini Toolbarbr /
br /
The Mini toolbar is a floating palette which automatically appears when you highlight text. Initially all the options it contains are discreetly dimmed. However, when you position the cursor over its controls, the Mini toolbar becomes activated.br /
br /
It contains a number of options for formatting your text. All of these options can be found in the Home tab of the Word Ribbon. The top row of icons allows you to change the font, size and colour of our text and also contains Words nifty Format Painter. The Format Painter allows you to copy the format of the selected text to other areas of your document.br /
br /
The second row of the Mini toolbar contains buttons for making text bold, italic, centre aligned. It also has options for changing the colour of the highlighted text, indenting text and inserting bullets.br /
br /
The Mini toolbar offers a very convenient way of quickly formatting your text without having to go back to the Ribbon to find the options youre looking for. However, there are times when it can be inconvenient. This is particularly true when using the drag-and-drop facility within Microsoft Word.br /
br /
This feature enables you to highlight text and simply drag it to a new location. However, as you are about to drag, its very easy for the cursor to collide with the Mini toolbar and instead of dragging your text you end up changing its format.br /
br /
As a Word user, youll decide whether you like the Mini toolbar facility. If you decide it is more trouble than its worth, Word allows you to deactivate this facility. From the Office button, choose Word Options. In the Popular category, the very first option is Show Mini Toolbar on selection. If you have had enough of the Mini toolbar, simply deactivate this option. Now, whenever you highlight text, the Mini toolbar will not appear.br /
br /
Even when you have asked Word not to display the Mini toolbar, it is still possible to show it by simply right-clicking on selected text.br /
br /
The author is a trainer and developer with TrainingCompany.Com, an independent computer training company offering a href=http://www.trainingcompany.com/microsoft-excel-training.asp target=_blankExcel 2007 Training Courses/a in London and throughout the UK.br /
br /
Grab practical suggestions in the sphere of a href=http://www.playstationexpert.com/play-station-tips/sony-playstation-advice-hints-and-tips.html target=_blankplaystation 3 cheap prices/a – your personal knowledge pack.

Be Sociable, Share!
Leave a Reply

You must be logged in to post a comment.

Entries RSS Comments RSS Log in