When you need to see how many formulas, Pivot tables or form controls you have in a worksheet or workbook, see the Statistics function of the workbook in Microsoft Excel. Is that how it works.
View statistics in Microsoft Word is useful to see the number of pages, words or characters. But getting statistics in Excel can be just as useful. You can have a workbook for a class with specific requirements, Or you may have a business spreadsheet that you want to check for unnecessary items..
Get workbook statistics in Microsoft Excel
You can view your workbook statistics at any time during the spreadsheet creation procedure and as many times as you like.
Open your Excel workbook and go to the Review tab. Click on “Workbook statistics” en la sección Revisión de la cinta.
When the small window opens, you will see your current sheet data at the top and the entire workbook at the bottom.
If you want to get details for a different sheet in your workbook, cierre la ventana Estadísticas del libro de trabajo haciendo clic en “To accept”. Subsequently, click on the tab for the sheet you want to view and follow the same steps listed above.
Data included in workbook statistics
You can see a decent amount of data with the Workbook Statistics feature. This is useful for situations where you expect to see something in your current sheet or workbook and you don't, or viceversa. Statistics differ slightly between the spreadsheet and the entire workbook. At the same time, note that most are counts (numbers) simple.
Spreadsheet statistics:
- The end of the blade (the last cell with data)
- Cells with data
- Tables and pivot tables
- Formulas
- Graphics
- Pictures and objects
- Form controls
- Comments and Notes
Workbook statistics:
- Number of sheets
- Cells with data
- Tables and pivot tables
- Formulas
- Graphics
- External connections
- Macros
You can view the workbook statistics in Excel for Microsoft 365 on Windows and Mac, as well as in Excel on the web. You can also access it in the same way on these platforms. The only difference is that Excel online does not show full data lists written above for sheets and workbooks.
