Shortcut menus and the Mini toolbar Excel 2013

show more Shortcut menus and the Mini toolbar provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training show less
please wait ...

Shortcut menus and the Mini toolbar

In Excel, the Right Mouse button always means "shortcut menu". It's a great feature because it alerts you to some of the commands and features you'd like to be able to use, and I say that based on the idea that Microsoft has done a lot of research about how people use Excel. The Excel Ribbon menu system which is quite extensive, can certainly be intimidating, and particularly, if you think of all the many, many buttons and choices that are available there. Suppose you want to make a formatting change in this worksheet and you click on cell A4, hold down the Left Mouse button and drag across the next three cells.

Now, you'd like to make some formatting changes. You're not quite sure where to find them, so let's right-click here. Now, this doesn't mean that what we're seeing is every possible command available--by no means at all. What we're really seeing here are some potential choices that we're likely we want to get to. Not only do we see this pop-up menu above it, we see a feature referred to as the "mini toolbar". For the most part, this consists of buttons and features that you'll find on the Home Tab, but is the Home Tab always the one that's currently active? Not necessarily.

These buttons, if we wanted to, for example, experiment a little bit with say a yellow background that looks yellow, well we'll click it and now it's yellow. While we're here, I don't think we want to change the font but we might and there's even a drop arrow there. We might want to use maybe a dark blue font and while we're here, we might want to use Bold. This is close to the data we are actually working with. Now, if we click somewhere else, the mini toolbar disappears. If you use the Right Mouse button in different locations, for example, if you were working with the Home Tab and you were to right-click on this button, for example here, you see some choices related to what you might be doing with that button.

This has nothing to do with commands in the worksheet necessarily, but it's again a reminder what the Right Mouse button does. If we right-click a column letter, the choices we see here are different, than if we were to right-click on a cell on the worksheet. For example, I'll right-click now on cell G3 and that's a different set of commands, some of them are the same, but some are different. If you right-click on a sheet tab at the bottom of the screen, as you might expect, a different set of choices there, and of course, these are related to the kinds of manipulation you might want to consider when dealing with sheet tabs.

So the right mouse button is really handy. Here's another idea too. Suppose you want to add a new column here to the left of column B, you might right-click on column B. You don't necessarily know which command it is, but "Insert" sounds like it's the one and so you might use that. At a later time you might say, "well, I don't really need that". "How might we get rid of it?" Well, you might right-click again on column B. By the way, you don't have to select it first. Right now D5 is active. I'm saying to myself, "I don't really want that column B there anymore".

So, I'll point to the B and right-click and there is "Delete". Although, not foolproof, the Right Mouse button is incredibly handy at times, because it pairs down the list of possible options that you're likely to want to use in any given situation. When it comes to formatting issues, that mini toolbar pops-up as well, and both of them are extremely helpful as you work with Excel.

Shortcut menus and the Mini toolbar
Video duration: 3m 24s 6h 32m Appropriate for all


Shortcut menus and the Mini toolbar provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training

Business Education + Elearning
please wait ...