Watch Calculation Results Immediately in Excel

In this article, we will learn to Watch Calculation Results Immediately in Excel.

What is the status bar and where to find the status bar in Excel?

Status bar is a horizontal bar, usually at the bottom of the screen or window, showing information about the running sheet or selected data. Status bar in Excel is basically a watch window to know the running status of the sheet. You can customize many features under the status bar. Here we learn how to look up quick results for the selected data on the status bar. Functions like

  1. Average
  2. count
  3. sum
  4. numerical count
  5. Maximum
  6. Minimum

You just need to select the required data and can watch all the stated results immediately, all together on the status bar. Let's learn how to watch the results on the status bar.

Example :

All of these might be confusing to understand. Let's understand how to use the function using an example. Here we have a sample data performing

As you can see in the above image that selected cell range is C4:C9 and the bottom bar indicated is the status bar.

Right click on the bar will open a drop down list as shown below.

This are the options available to view on status bar. All the tick options are shown as enabled and the untick are the disabled ones. The bow indicated shows the calculation performing options. Tick the ones you want to view on status bar.

After ticking the ones, you are ready to evaluate results. Now select the range you need to evaluate.

As you can see the Average : 82500  Count : 6  Numerical Count : 6     Min : 55000  Max : 120000 and Sum : 495000 for the selected cells.

Here are all the observational notes using the results displayed on status bar in Excel
Notes :

  1. Results displayed are temporary and can't be copied or edited and results vanish, if the selected cell is shifted to a blank cell.
  2. If you want the results to copy and paste or use it another formula either you have to type the numerical value or use the standard AVERAGE, COUNT, MIN, MAX or SUM functions.

Hope this article about Watch Calculation Results Immediately in Excel is explanatory. Find more articles on Excel tips and tricks here. If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.

Related Articles:

All About Excel Named Ranges : excel ranges that are tagged with names are easy to use in excel formulas. Learn all about it here.

The Name Box in Excel : Excel Name Box is nothing but a small display area on top left of excel sheet that shows the name of active cell or ranges in excel. You can rename a cell or array for references.

How to Get Sheet name of worksheet in Excel : CELL Function in Excel gets you the information regarding any worksheet like col, contents, filename, ..etc.

How to use Dynamic Named Ranges in Excel : A dynamic name range is a name used for the array or range that expands and shrinks according to data. Learn more about dynamic named ranges here.

How to Create Drop Down List with Color in Excel : Add colors to the drop down list in Excel using Conditional formatting and data validation.

Join first and last name in excel : Join two or more values or names using the CONCATENATE function or & operator. This article explains how to add two or more cells in Excel.

Popular Articles :

How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.

How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.

How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.

How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube