在创建电子表格等方面， Microsoft Excel^{(Microsoft Excel)}是相当强大的。就所提供的功能而言，没有其他类似的工具，这就是为什么Excel是同类产品中最好的工具。

如何查看Excel工作簿统计信息

Excel的最佳功能之一是能够查看您的工作簿^(Workbook)统计信息。您可以查看与文档中单元格数量相关的数据。但不仅如此，用户还可以查看图表、表格等信息。

此功能与您在Microsoft Word中找到的功能非常相似，因此，如果您是喜欢查看具有更深含义的单词和数字的人，那么这绝对适合您。

单击功能区中的“审阅”选项卡

要开始查看与您的Excel文档相关的统计信息，您必须首先单击“查看”^(Review)选项卡。您应该会看到大量可供选择的选项，这对于流行电子表格平台的业余用户来说可能有点混乱。

查看您的工作簿统计信息

单击Review后，您现在应该通过文档的左上角选择Workbook Statistics按钮。^(Statistics)完成后，您应该会看到一个小弹出窗口，其中显示了打开的Excel文档的统计信息。

这是位于统计信息中的信息

如果您对Workbook ^(Workbook) Statistics将显示的所有可能数据感到好奇，那么请看下面并感到惊讶：

工作表级别^{(Worksheet level)}

• 工作表结尾/最后一个单元格
• 包含数据的单元格计数
• 表数
• 数据透视表计数
• 公式计数
• 图表数
• 图像计数
• 表单控件的计数
• 对象数
• 评论数
• 笔记数

工作簿级别^{(Workbook level)}

• 张数
• 包含数据的单元格计数
• 表数
• 数据透视表计数
• 公式计数
• 图表数
• 外部连接数
• 宏计数

如果您想了解更多信息，请在评论部分留言。

阅读下一篇^{(Read next)}：How to remove #DIV/0! error in Microsoft Excel。

How to view and track Excel workbook statistics

Microsoft Excel is quite the powerhouse when it comes down to creating spreadsheets, among other things. There is simply nothing else like it in terms of features offered, which is why Excel is the best tool in its category.

How to view Excel workbook statistics

One of the best features of Excel is the ability to view your Workbook statistics. You can have a look at data relating to the number of cells located in a document. But not only that, users can view information on charts, tables, and much more.

This feature is quite similar to what you’ll find in Microsoft Word, so if you’re the type of person who enjoys looking at words and numbers with deeper meanings, this is definitely for you.

Click the Review tab in the Ribbon

To begin the process of looking at statistics relating to your Excel document, you must first click on the Review tab. You should see a ton of options to choose from, which might be a bit confusing for amateur users of the popular spreadsheet platform.

View your Workbook Statistics

After clicking on Review, you should now select the Workbook Statistics button via the top-left corner of the document. Once that is done, you should see a small pop-up window showcasing the statistics of the opened Excel document.

Here is the information located in the statistics

If you’re curious about all the possible data the Workbook Statistics will display, then look below and be amazed:

Worksheet level

• End of sheet / Last cell
• Count of Cells with Data
• Count of Tables
• Count of PivotTables
• Count of Formulas
• Count of Charts
• Count of Images
• Count of Form Controls
• Count of Objects
• Count of Comments
• Count of Notes

Workbook level

• Count of Sheets
• Count of Cells with Data
• Count of Tables
• Count of PivotTables
• Count of Formulas
• Count of Charts
• Count of External Connections
• Count of Macros

If you want more information, please leave a word in the comment section.

Read next: How to remove #DIV/0! error in Microsoft Excel.

Related posts

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel中使用Automatic Data Type feature

• 如何在Excel中使用DISC function

• 如何在Excel中使用DGET function

• 如何Merge and Unmerge cells在Excel

• 如何在Microsoft Excel中提取URLs中的域名

• 如何在Excel创建和使用Form Controls

• How以使用Excel的Mode function

• 如何在Excel中使用Rept Function

• 如何在Windows 11/10中创建Tournament Bracket

• 如何更改Excel worksheet Tab的颜色

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 如何在Excel中使用Find and FindB functions

• 如何计算Excel中的百分比increase or decrease？

• 如何使用OR function Excel确定条件是否为真

• 运行时error 1004，不能在Excel运行Macro

• 如何在Excel spreadsheet中插入Dynamic Chart