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 show you where to find the Quick Access toolbar, what are the available buttons, and how to add and remove buttons according to your own preference and usage. You will also learn how to customize the Quick Access Toolbar in the Excel Options, as well as how to reset it to its default setting.

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 ;-)

Welcome back to our course on Excel 2016.
In this section we’re going to look at the Quick Access Toolbar which is a toolbar I’ve pointed out a couple of times before. It’s in the top left hand corner of the main window and it’s used as the name implies for quick access to a small number of commands.
Now by default you will see a small selection of commands displayed there. Let me just hover over the ones here. There’s a Save, an Undo Underline. Now the reason it says Undo Underline is because the last thing that I did on this sheet was to underline something and therefore to do an Undo that’s the thing I would be undoing. In fact if I click on the little dropdown to the right there it’s got a list of the last few things that I’ve done. So I can either Undo one of them or I could go back and Undo more than one of them. It’s not highlighted at the moment but there is a Redo button which will be available if I’ve undone something I’ll be given the option to redo it if I change my mind. There’s then the Touch/Mouse Mode button that we’ve used earlier in the course and then a couple of other buttons.

If I click on the dropdown at the right it gives me a list of the available buttons. And the ones that are ticked are the ones that are currently visible. If I wanted to say show an Open button as a Quick Access button, if I just click on Open that’s available. If I decided that I wasn’t going to be regularly switching between Touch and Mouse Mode I could make the Touch/Mouse Mode button invisible as well.
So that’s a very simple way of customizing what’s shown in the Quick Access Toolbar.

Now if we go back to that menu you notice at the bottom there is a command there, Show Below the Ribbon. Some people prefer to have the Quick Access Toolbar below the Ribbon. One of the reasons is that if you’re doing something where you’ve set up some Quick Access Commands rather than have to move the cursor across the Ribbon to get at your commands putting the Quick Access Toolbar just above the workbook, the worksheet that you’re working on, makes it a slightly less onerous task going up to the commands. Let me just show you what happens. Show Below the Toolbar puts the Quick Access Toolbar there. And then when you’re working on a worksheet you can very quickly and easily get to the Quick Access Toolbar. And of course it’s very straightforward to put it back above the Ribbon again.

Another very simple customization, let me click on that again, is to go down to where it says More Commands. And you may recall me saying in the previous section that I’ll give you a very quick demonstration of customization of the Quick Access Toolbar. It’ll give you some clues about customization of the main Ribbon.


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