Helpdesk Baruch College

How to Get Workbook Statistics in Microsoft Excel

When you need to see the amount of solutions, pivot tables, or develop controls you have in a spread sheet or workbook, look into the Workbook Statistics function in Microsoft Excel. Right here’s exactly how it works.

Checking out statistics in Microsoft Word is practical for seeing the variety of pages, words, or personalities. Yet obtaining data in Excel can be equally as useful. You might have a workbook for a course with details needs, or you may have a spreadsheet for business that you intend to examine for unneeded elements.

Get Workbook Statistics in Microsoft Excel

You can watch your Workbook Statistics at any point in your spread sheet production process, and as many times as you like.

Open your Excel workbook and head to the Review tab. Click “Workbook Statistics” in the Proofing area of the ribbon.

When the little window opens, you’ll see information for your existing sheet on top and the whole workbook at the bottom.

If you want details for a different sheet in your workbook, close the Workbook Statistics window by clicking “OK.” After that click the tab for the sheet that you wish to see and follow the exact same steps listed above.

Data Included in Workbook Statistics

You can see a decent amount of data with the Workbook Statistics attribute. This is handy for scenarios where you expect to see something in your current sheet or workbook and also you do not, or vice versa. Data differ somewhat in between the spreadsheet as well as the whole workbook. Additionally, remember that most are simple counts (numbers).

Spread sheet Statistics:

Workbook Statistics:

You can check out Workbook Statistics in Excel for Microsoft 365 on Windows as well as Mac in addition to in Excel on the internet. You can additionally access it in the same way on these platforms. The only distinction is that Excel online does not present the full data checklists written above for sheets as well as workbooks.

Exit mobile version
Skip to toolbar