Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

During this Microsoft Excel 2016 training tutorial video, we will take a look at what is a contextual menu and a mini toolbar. We will also demonstrate how to make a smaller version of a mini toolbar appear, as well as how to enable the touch version of the mini toolbar and contextual menu.

Checkout some of our other training on YouTube:

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX

Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016.
In this very short section we’re going to take a look at Mini Toolbars and Contextual Menus.

Now apart from using the Ribbon and the Quick Access Toolbar there are various other ways of accessing commands that are relevant to a particular situation or a particular action. And typically in a situation you may call up what’s called a Contextual Menu.

Now it’s called Contextual because what’s on it is in the context of what’s going on at that time.
So looking at this Demo 1 workbook here, for example, if I right click on it up comes a Contextual Menu. It has commands on it which Excel thinks are the most likely ones that I’m going to want to use at that time: Cut, Copy, Paste Options, and so on. Note also the Smart Lookup there.

And then above the Contextual Menu there is a Mini Toolbar which gives me one click access to some of the things that I might want to do. So for example, I may want to switch off Bold. Well there’s a simple button there, a Bold button. Click on that and the text Hello There is no longer bold.

So that’s the Contextual Menu and a Mini Toolbar.

Now there is another version of that available. Let’s take a quick look at that.

If I want to select the text Hello and as you’ll see later on that is quite different from selecting the whole cell that the word Hello is in. That is the cell J10. If I click to the right of Hello in the Formula Bar and then go back and hover over the cell you will see that I can click in and the cursor is now flashing in the cell. If I now click with the mouse, drag across the word Hello and release the mouse button I’ve made a selection within a cell, in this case the word Hello. And what comes up is an even minier toolbar, a tiny little mini toolbar, a toolbar on select. And some people like those, some people don’t. In fact some people don’t like toolbars in general because they tend to get in the way of things. But that’s another way of bringing up a little mini toolbar that you can use in some situations, for instance to just quickly be able to make something Bold or Italic or change the color of some text.


Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.