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 quick look at the status bar and how to customize it. We will show you what things you can find in the status bar, including the different page views, as well as how to enable or disable controls.
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.
We’re now going to take a very quick look at the Status Bar which is at the bottom of the Excel 2016 workspace.
It’s actually pretty straightforward to control the Status Bar. What I’m going to do is to put the cursor down over the Status Bar, right click on it and you get this long Customize Status Bar sort of menu. And it’s a list of all the things that can appear on that Status Bar.
Now everything that’s ticked can appear. And you may look at that list of ticked things and say well there seem to be about 20 things there but I can only see half a dozen. Some of the things if they’re ticked will still only appear if they have a certain value. Whereas some of them will give an indication whatever their value. So for example, if you take the very top one, Cell Mode, the current Cell Mode is Ready. Now if you look at the Status Bar, bottom left hand end, Ready, you can see that the Cell Mode is Ready. Don’t worry about what Cell Mode means at the moment, just take it as Ready. There are then a couple of options, Flash Fill Blank Cells, Flash Fill Change Cells. We’ll come back to those later on. Signatures, Information Management Policy, etcetera. A whole list of things, many of which are ticked and some of which are not.
Now let me tick one of the ones that isn’t. I’m going to tick Caps Lock. And if I tick Caps Lock then Caps Lock would show on the Status Bar if I actually enabled it. So let me now press the Caps Lock key on my keyboard and you can see that Caps Lock is now showing as On. If I click the Caps Lock key again, switch it off, then you don’t see it any longer. If I didn’t have Caps Lock ticked here then you wouldn’t see whether Caps Lock is on or off. I hope that’s an adequate explanation. So really the ticks say do I want to see an indication of this thing or do I not want to see an indication of this thing. Now I don’t normally need to see Caps Lock on the Status Bar so I don’t normally have that checked.
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.