• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Workbook Statistics in Excel

September 14, 2021 by Andrew Childress
Workbook statistics Excel

As you work in Excel spreadsheets, it’s easy to quickly build enormous, complex files. Let’s learn how to use Workbook Statistics in Microsoft Excel.

As you work in Excel spreadsheets, it’s easy to quickly build enormous, complex files. Sometimes, it’s useful to know exactly how much information you have on your sheets. Fortunately, Excel offers a quick and easy way to count these key details. Let’s learn how to use Workbook Statistics in Microsoft Excel.

How to Use Workbook Statistics in Excel

Workbook Statistics is a dashboard inside Excel that offers a quick summary of the dimensions of your workbooks. Among other things, it measures your sheets’ ending cells, the number of cells containing data, the number of formulas, and more. These values are returned for both individual worksheets and your complete workbooks.

Workbook Statistics can be viewed for any Microsoft Excel spreadsheet. To get started, begin by finding the Review tab.

Workbook statistics Excel

This sits on Excel’s ribbon, the array of menu tabs across the top of your screen. Click Review to open up the tab.

Excel workbook statistics

You’ll see an array of options displayed. The one you need is third on the left side of the Review tab: Workbook Statistics. Go ahead and click on it, and Excel will launch the Workbook Statistics dashboard.

As you can see, Workbook Statistics displays an array of useful information about your spreadsheet. At a glance, you can see how many cells contain data, for example. Plus, the feature counts formulas, total sheets in the workbook, and more.

Workbook statistics in Excel

This is useful for any file, but especially so in cases like this where Excel files contain dozens or hundreds of sheets, thousands of formulas, and countless cells filled with data.

Counting these elements would be cumbersome, if not impossible – and it’s also unnecessary. That’s all thanks to the powerful, easy-to-use Workbook Statistics feature inside Microsoft Excel. Try it any time you need to quickly analyze the volume of information packed into your spreadsheet files.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to use Xlookup in ExcelXLOOKUP in Excel
Next Post:Formula Builder in ExcelFormula builder Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top