How to view Workbook Statistics in Excel

This statistics book helps users to quickly manage the content that you have used in the data table. The following article will guide you how to use the workbook feature in Excel.

Instructions for using Workbook Statistics Excel

Step 1:

First, you open the Excel file you want to see the workbook statistics. Next at the Ribbon, click on the Review tab and then look down below and click on Workbook Statistics .

How to view Workbook Statistics in Excel Picture 1

Step 2:

Now display the window interface with full data of the current spreadsheet. If you work in multiple sheets, the top will be the statistics of the current sheet and the bottom will be the statistics for the entire document.

Each section will list very detailed content for us to follow.

Spreadsheet statistics:

1. The last cell of the spreadsheet.
2. Total number of cells with data.
3. Tables and PivotTables.
4. Formulas used in the table.
5. Images and objects.
6. Form controls button.
7. Notes in the sheet.

Statistics of all files:

1. Number of sheets in the file.
2. Number of cells with data in the entire file.
3. Usage table.
4. Usage formula.
5. Insert chart in Excel.
6. Macros.

Depending on the content you use in the sheet or in Excel, the statistical content will be displayed differently, but will basically summarize the above content.

How to view Workbook Statistics in Excel Picture 2

Samuel Daniel

Update 20 May 2021