• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Excel Tutorials

Microsoft Excel Tutorials

  • Home
  • Microsoft Excel Tutorials
  • Learn
    • Formulas
    • Power Query
    • Errors
    • Videos
    • Charts
    • Shortcuts
    • Pivot Tables
    • Macros
    • Basics
    • Analysis
  • 240+ Excel Shortcuts
  • Privacy Policy
You are here: Home / Analysis / How to Customize Excel Footer Status?
How to Customize Excel Footer Status?

How to Customize Excel Footer Status?

posted on June 11, 2020

Excel footer status shows various valuable statistics of your data in your worksheet that you may not know about. In this section, I will let you know how to customize Excel Footer status for your daily excel needs.

Here we have the following demo data which have 6 columns including ID, first name, Last name, Join date, Gender and their sales data;

excel footer status

Excel footer status will be show below it as follows;

excel footer status

Now, When you click on sales data column, you can see some status which is being shown in excel footer bar;

excel footer status

Here you can see default status value of “Count” and “Numerical Count”. Count includes all values in that particular column you have selected i.e. Sales which included its header itself and Numerical Count as name suggests tells you the number of numerical values in the same.

Suppose, you want to analyze all the sales data by;

Minimum and Maximum Sales Number

Here you can find the minimum and maximum amount of sales incurred by your employees just right-clicking on the same excel footer bar and select minimum for lowest amount of sale and maximum for the highest record number by your employee.

excel footer status

Here you can see minimum amount of sale is 104.92 and highest recorded is 998.4 in your excel footer bar.

Average of Sales

Suppose you want to calculate average of all sales values you have selected in your excel footer bar you can do the same by right-clicking on it and select average.

excel footer status

now we get the average of selected value i.e. 547.9456 in our footer;

excel footer status

Sum of All Sales

Now i assume you have got what I’m trying to convey until this step, similarly, if you want to calculate sum of all selected sales values, you can do the same as before;

excel footer status

Other Important Statistics

Excel footer statistics are not limited to only sum, average, max or minimum variables but you can also analyze other important statistics listed when you right click on it as follows;

excel footer status

Here, you can see the list of status you can customize according to your need, but we may not need all of them so you can unselect the ones you don’t need and select which is suitable for you and your daily excel need.

Hope, you got the point we want to convey in this tutorial, if you have any questions in mind please drop it in below comment box.

How to create Hyperlink with VLOOKUP?

Filed Under: Analysis, Basics Tagged With: excel footer, excel footer statistics, excel footer status

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar

Download 240+ Shortcuts

Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.

Categories

  • Basics
  • Formulas
  • Pivot Tables
  • Charts
  • Power BI
  • Analysis
  • Shortcuts
  • Macros
  • Add-Ins

Recent Comments

  • Olivia on Convert Formulas to Values in Excel
  • Pkv on How to Insert Comment In Power Query Steps?
  • Rahul on How to Insert Comment In Power Query Steps?
  • David on How to Insert Comment In Power Query Steps?
  • sofia on How to use Workday Formula in Excel?

Footer CTA

Get Weekly Updates in your mailbox

Get Started Now

Copyright © 2021