قالب وردپرس درنا توس
Home / Tips and Tricks / Get workbook statistics in Microsoft Excel

Get workbook statistics in Microsoft Excel



Microsoft Excel logo

If you want 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. This is how it works.

Viewing statistics in Microsoft Word is useful to see the number of pages, words or characters. But getting statistics in Excel can be just as useful. You may have a class workbook with specific requirements, or you may have a business spreadsheet that you want to check for unnecessary elements.

Get workbook statistics in Microsoft Excel

You can view your workbook statistics at any time during the creation of your spreadsheet and as often as you want.

Open your Excel workbook and go to the Review tab. Click on “Workbook Statistics”

; in the trial area of ​​the ribbon.

Click Workbook Statistics on the Review tab

When the small window opens, you will see the data for your current sheet at the top and the entire workbook at the bottom.

Workbook statistics in Excel

If you want details for another sheet in your workbook, close the Workbook Statistics window by clicking “OK”. Then click on the tab for the sheet you want to see and follow the same steps above.

Workbook statistics for two sheets

Data included in workbook statistics

You can see a fair amount of data with the Workbook Statistics feature. This is useful for situations where you expect to see something in your current sheet or workbook and you don’t, or vice versa. Statistics are slightly different between the spreadsheet and the whole workbook. Also keep in mind that most are simple counts (numbers).

Spreadsheet Statistics:

  • The end of the sheet (the last cell with data)
  • Cells with data
  • Tables and pivot tables
  • Formulas
  • Graphs
  • Pictures and objects
  • Form control
  • Comments and remarks

Workbook statistics:

  • Number of sheets
  • Cells with data
  • Tables and pivot tables
  • Formulas
  • Graphs
  • External connections
  • Macros

You can view workbook statistics in Excel for Microsoft 365 on Windows and Mac, and in Excel on the web. You can also access it in the same way on these platforms. The only difference is that Excel Online does not display the full data lists written above for worksheets and workbooks.





Source link