Get Quick Statistics About Your Excel Workbook.


Hello, Excellers. I think this next #Excel tip will come as a relief, especially if you have inherited a workbook. Yes, quick statistics about your Excel workbook are now available.!. You may need to know how many Pivot Tables, Macros, formulas and tables you have in a workbook. This new feature was made available in April 2020. It is now available in the following versions.

  • Excel for Microsoft 365
  • Mac Excel 2016 
  • Excel for iPad, iPhone, Android tablets 
  • Equation Editor for Mac 2011 
  • Excel for Android phones Whiteboard

It is easy to access the workbook statistics information following the steps below:-

Click Review Tab | Proofing Group | Workbook Statistics.

Excel workbook statistics

This information is available at both the current worksheet level with the following details available at the current WORKSHEET level.

workbook statistics

At the WORKBOOK level the following statistics are available.

Excel workbook statistics

In my example workbook, I have 2 sheets, 3 cells with data, 1 Pivot table and many more items.  Pretty handy statistics.

I know if I need to find how may Pivot Tables are in an inherited workbook now, I do not need to write any code to find out. Just hit this new feature.?

Do You Prefer Excel Shortcuts?.

If you like to use shortcuts then you can easily access the same worksheet and workbook statistics by the following keys:

Ctrl+Shift+G

Excel Macro

So, if you want more tips then sign up for my Monthly Newsletter. I share 3 Tips on the first Wednesday of the month. You will receive my free Ebook, 50 Excel Tip.

Watch The Video If You Prefer!.

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts