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.
This sits on Excel’s ribbon, the array of menu tabs across the top of your screen. Click Review to open up the tab.
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.
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.