And some people like those, some people don’t. And what comes up is an even minier toolbar, a tiny little mini toolbar, a toolbar on select. 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. 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 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. Now there is another version of that available. Want More? Get Started With a Free Excel 2016 Course! Click Here So that’s the Contextual Menu and a Mini Toolbar. Click on that and the text Hello There is no longer bold. Well there’s a simple button there, a Bold button. So for example, I may want to switch off Bold. Note also the Smart Lookup there.Īnd 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.

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. So looking at this Demo 1 workbook here, for example, if I right click on it up comes 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. And typically in a situation you may call up what’s called a Contextual Menu. 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. In this very short section we’re going to take a look at Mini Toolbars and Contextual Menus. Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners.

Microsoft Visio 2010 – 9 Hours Video Training.

Power Pivot, Power Query and DAX in Excel.

Adobe Photoshop Elements 11 – 12 Hours Video Training Course.

Microsoft word mini toolbar