Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

This tutorial discusses the Microsoft Excel 2013 Mini Toolbar. The Excel 2013 Mini Toolbar is context-sensitive, which means what the Mini Toolbar contains and what you can do depends on the context/situation. The Excel Mini Toolbar can be turned on and off, according to your preference. In this video, learn how to enable, how to use, and how to disable the Excel Mini Toolbar.

Get the full course on Excel 2013 course here: https://www.simonsezit.com/course-category/excel/

Stay in touch:
Facebook: http://on.fb.me/14m8Rwl
StreamSkill.com: https://StreamSkill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

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

Welcome back to our course on Excel 2013. In this very short section, we’re going to look at the Mini Toolbar. Now as you may have noticed already and you’ll certainly know about this if you’ve used earlier versions of Excel or in fact just about any relatively recent version of one of the Office products that you can right click on something and you get a contextual menu.

Here’s a typical contextual menu just by right clicking on that cell in that worksheet. Maybe the sort of thing you’ve seen many times before. What you may not have seen is the thing above it which is what we call in Excel 2013 the mini toolbar and it generally appears when you’re dealing with anything where you can enter text, numbers, etc. And it gives you a way of formatting very quickly without going to either the Ribbon or to specific commands on the Quick Access Toolbar. Now the mini toolbar not everybody likes to use.

I do tend to use it. But for some people it tends to clutter up quite a few things and people can often find it quite difficult to grab exactly the command that they want. But if you are going to use it I’m going to give you a quick demonstration of using it and then I’m going to show you how to enable or disable it.

Now the first thing to note about it is that it is context sensitive. So if in this particular cell now H3, I just type the word Hello. If I now sweep over that to select the word Hello, the mini toolbar appears and you see its got quite a restricted set of commands on it. It has commands that let me choose the font and the font size. So I could change the font size quite say to 24 point which would make that word much bigger. I could change the font to, for instance, Adobe Hebrew and I could go Bold and that’s fine. But I’ve only got really quite a restricted set of commands there on that mini toolbar. If I go to an empty cell such as this one and right click as I did earlier on, I get a fuller set of commands and a much bigger mini toolbar. So exactly what it contains and what you can do depends on the context, depends on the situation.

So let’s now look at how we can switch the mini toolbar on and off. Obviously, we go into Options and then on the General tab almost the top thing on there, User Interface Options, Show mini toolbar on selection. If you don’t want the mini toolbar uncheck that, click on OK to save your change, and no more mini toolbar.

Now I don’t really need to say anything more about the mini toolbar. I’m going to be using it a little throughout the course. It’s your choice whether you use it or not. I’ll see you in the next section.