Check Workbook Statistics

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

Click Review > Proofing > Workbook Statistics. You can also press CTRL+SHIFT+G.

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.

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

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×