If you need to see how many formulas, pivot tables, or form controls you have in a spreadsheet or workbook, check out the Workbook Statistics feature in Microsoft Excel. Let’s explore this feature.
This is for devices running Excel. Screenshots are from Excel in Office 365 on Windows 10
You may have found statistics in Word helpful for seeing the number of pages, words, or characters. Getting statistics in Excel can be just as useful. You may have a workbook for a class with specific requirements, or you may have a spreadsheet for business that you want to review for unnecessary elements.
View Your Sheet/Workbook Statistics
First, open your Excel workbook. Next, navigate to the Review tab. Now, click Workbook Statistics in the Proofing section. You can also press Ctrl+Shift+G. (Note that the shortcut will not work in Excel for the Web.) Refer to below image:
Now, a small window will open to display the data for your current sheet at the top and the entire workbook at the bottom. See below image:
If you want details for a different sheet in your workbook, close the Workbook Statistics window by clicking OK. Next click the tab for the sheet that you want to see and follow the same steps listed above. As a downside, the sheet and workbook name are not shown. See following image:
Data Included
You can see a the following data with the Workbook Statistics feature. This is helpful for situations where you expect to see something in your current sheet or workbook and you do not, or vice versa. Statistics may differ slightly between the spreadsheet and the entire workbook.
Spreadsheet Statistics:
- The end of the sheet (the last cell with data)
- Cells with data
- Tables and PivotTables
- Formulas
- Charts
- Images and objects
- Form controls
- Comments and notes
Workbook Statistics:
- Number of sheets
- Cells with data
- Tables and PivotTables
- Formulas
- Charts
- External connections
- Macros
You can view Workbook Statistics in Excel for Microsoft 365 on Windows and Mac as well as in Excel on the Web. The only difference is that Excel online does not display the complete data lists written above for sheets and workbooks.
The scientific theory I like best is that the rings of Saturn are composed entirely of lost airline luggage.
Mark Russell
That’s it. Please feel free to share this post! One way to share is via Twitter.
Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.
Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.
Tweet
I Would Like to Hear From You
Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.
Tech Savvy Life 