So, Hello Excellers, and welcome back to another #formulafriday blog post. Today is a little different as this blog post centers in the Excel status bar. That is correct, We will not be using a formula. For this great Excel tip, we do not even need to type an equals sign. We do not need to enter anything into a cell to calculate the maximum value in our Excel data set. So I guess this is a #notaformulafriday blog post. Figure!.
Let’s start with a data set a bit like my example below. We want to find the largest or the maximum value in the data set. So, we could use a few formulas we have in our Excel formula toolbox. But, if we want a quick visual of the maximum value, we do not need to go near any formula.
So, all we need to do is use the Excel Status Bar to give us these quick calculations.
Where Is The Excel Status Bar?
First, let’s take a step back and look at the Excel Status Bar. The bar located at the bottom of the Excel window where it displays valuable and exciting information, including the maximum value in the data set. So, how handy is that?.
More Options Available In The Excel Status Bar.
Selecting The Options.
So, to select or deselect any of the options that are available simply right click on the bar. Therefore, just select or deselect your required option. Easy as that.
Use The Status Bar To Display The Maximum Value In Your Excel Data Set.
- Select the data set on your Excel worksheet by using ALT+A keyboard shortcut or selecting with the mouse
- Depending on your selection of functions in the Status Bar you will see the maximum value in our data set. In this case, this set is €38,577.00
It is as easy as that. So, we can also see the Average of our data set, as well as a count of the number of records. Handy?.
So why not explore the options that are available on the Excel Status Bar?.
So, What Next? Want More Tips?
Finally, if you want more Excel and VBA tips then sign up for my Monthly Newsletter where I share 3 Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips and check out all of my Formula Friday Blog posts below.
Do You Need Help With An Excel Problem?.
Finally, I am pleased to announce I have teamed up with Excel Rescue, where you can get help with Excel FAST. Why not check it out?.