Workbook Statistics in #Excel 365

Whichever version of Excel you are using, you will see a lot of useful information about your worksheet/workbook in the Status Bar. Having said, many users are not aware of the presence of the status bar. Are you one of them?

Today, I want to highlight the “Workbook Statistics” which is available in Excel 365.

Simply click on it, then it will open the following dialog box:

As you see, you can see the key statistics of the current sheet and the current workbook. I like the first info – End of sheet the most. Why? Because it is always the first thing I investigate when someone called me asking “Why is my file size so big when I have only a few data points?”. 🤔

Before the “Workbook Statistics”, I need to ask the user to press Ctrl+End which I found challenging sometime (coz many people don’t know what Ctrl+End does, and they would press Ctrl+N instead) 😅.

Tip: The "Workbook Statistics" can only be found under "Review Tab".  Currently available in Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021

What? You are using Excel 365 but couldn’t find “Workbook Statistics” on the status bar? No worries! Right click anywhere on Status Bar and you can customize what info to be displayed on it.

This is a small feature, but I like it. What do you think? Do you think it is helpful? Please leave your comment below!

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel 365, Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.