Excel 2010 – Ch. 01: J – Shortcut Menus & Mini Toolbars

Posted 1 years 56 days ago ago by Babu     
  • Currently 0.00/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Part J: Shortcut Menus & Mini Toolbars

In addition to the Ribbon, Excel provides many shortcut menus, which you can access by right-clicking on certain areas of Excel. A shortcut menu is a list of frequently used commands that relate to the right-clicked object. Shortcut menu will not provide you every command that is relevant to the right-clicked object, but it just displays those commands that are most commonly used related to the right-clicked object.

For example, right-click on a scroll bar and a shortcut menu appears with commands related to the scroll bar. You get a different menu when you right-click on the Quick Access Toolbar, a shortcut menu appears with commands related to the Quick Access Toolbar. You can use shortcut menus to access common commands quickly.

C01-J 01

Check out the image above, you can see two different shortcut menus in it (the image is modified to show both the shortcut images together). While the one on the right side of the image is what we get when you click on a cell, the other shortcut menu is what we get when you click on the chart. Notice the commands that are listed on the chart, they contain commands that are pertinent to the chart.

Also notice a small toolbar above the shortcut menu. That is the Mini toolbar, which contains commonly used tools from the Home tab. While the commands are also available in the tab, it is designed to make it easy to use excel by reducing the distance the mouse has to travel to access them on the ribbon tab. The Mini toolbar becomes more useful when a tab other than the Home tab is selected by the user.

Also notice the Mini toolbar also changes a little based on the object with which it appears. While it shows the Formula and Merge & Center commands with the cell, for a chart, it displays a Chart Elements dropdown. I would suggest you to start playing around with the Mini Toolbar and you will get to see the changes in commands as well as how useful it will be in working with excel.

Advanced Concepts – C01-J-01

Note: Advanced concepts section is scattered throughout this tutorial. Look out for them, since our team feels that it makes more impact to explain them when we are covering the respective features.

However useful some features may be, for some people it becomes a kind of annoying. If you find the Mini toolbar annoying, then Excel 2010 does not provide any command or an out of the box solution to turn it off. Though the General tab of the Excel Options dialog box has an option labeled Show Mini Toolbar on Selection, this option applies only for selecting characters while editing a cell.

But with VBA, you can always achieve what is not possible directly and same is true for hiding the Mini Toolbar.

   1: Sub HideMiniToolbar()
   2:     Application.ShowMenuFloaties = True
   3: End Sub

This VBA code will make the Mini Toolbar disappear. If you notice the code, you might think that it may be wrong since I am setting the property to True, but it’s actually correct. It was a bug that continues from Excel 2007 and Microsoft did not fix it even for Excel 2010, since correcting it may result in a lot of macros using this code to fail.

I will cover VBA, short for Visual Basic for Applications later on in this Tutorial.

Leave Your Comments