Wondering how big your worksheet or workbook is getting? Excel provides workbook statistics to help you.

Select the Review tab, and then, in the Proofing section, select Workbook Statistics. You can also press CTRL+SHIFT+G. (Note that the CTRL+SHIFT+G shortcut won't work in Excel for the web.)

The Workbook Statistics command on the Excel ribbon

The Workbook Statistics dialog opens and displays counts and other information about the current worksheet and workbook. (Excel for the web shows some but not all of the information shown in the image.)

The Workbook Statistics dialog.

What is counted by Workbook Statistics

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×