{"id":251622,"date":"2021-05-17T17:24:56","date_gmt":"2021-05-17T14:24:56","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-get-workbook-statistics-in-microsoft-excel\/"},"modified":"2021-05-17T17:24:56","modified_gmt":"2021-05-17T14:24:56","slug":"how-to-get-workbook-statistics-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-get-workbook-statistics-in-microsoft-excel\/","title":{"rendered":"#How to Get Workbook Statistics in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2e43fb593d3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2e43fb593d3\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-get-workbook-statistics-in-microsoft-excel\/#Get_Workbook_Statistics_in_Microsoft_Excel\" >Get Workbook Statistics in Microsoft Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-get-workbook-statistics-in-microsoft-excel\/#Data_Included_in_Workbook_Statistics\" >Data Included in Workbook Statistics<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Get Workbook Statistics in Microsoft Excel&#8221;<\/strong><\/p>\n<div id=\"post-724325\">\n<div class=\"entry-content e-content\">\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-725718\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?width=1200&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you need 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. Here\u2019s how it works.<\/p>\n<p>Viewing statistics in Microsoft Word is helpful for seeing the number of pages, words, or characters. But getting statistics in Excel can be just as useful. You may have a workbook for a class with specific requirements, or you may have a spreadsheet for business that you want to review for unnecessary elements.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Get_Workbook_Statistics_in_Microsoft_Excel\"><\/span>Get Workbook Statistics in Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can view your Workbook Statistics at any point in your spreadsheet creation process, and as many times as you like.<\/p>\n<p>Open your Excel workbook and head to the Review tab. Click \u201cWorkbook Statistics\u201d in the Proofing section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724329\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/ReviewWorkbookStatistics-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Workbook Statistics on the Review tab\" width=\"636\" height=\"159\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the small window opens, you\u2019ll see data for your current sheet at the top and the entire workbook at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724328\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/WorkbooksStatisticsWindowNext-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Workbooks Statistics in Excel\" width=\"238\" height=\"381\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want details for a different sheet in your workbook, close the Workbook Statistics window by clicking \u201cOK.\u201d Then click the tab for the sheet that you want to see and follow the same steps listed above.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724327\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/WorkbooksStatisticsTwoWindows-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Workbooks Statistics for two sheets\" width=\"493\" height=\"381\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Data_Included_in_Workbook_Statistics\"><\/span>Data Included in Workbook Statistics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can see a decent amount of data with the Workbook Statistics feature. This is helpful for situations where you expect to see something in your current sheet or workbook and you don\u2019t, or vice versa. Statistics differ slightly between the spreadsheet and the entire workbook. Also, keep in mind that most are simple counts (numbers).<\/p>\n<p>Spreadsheet Statistics:<\/p>\n<ul>\n<li>The end of the sheet (the last cell with data)<\/li>\n<li>Cells with data<\/li>\n<li>Tables and PivotTables<\/li>\n<li>Formulas<\/li>\n<li>Charts<\/li>\n<li>Images and objects<\/li>\n<li>Form controls<\/li>\n<li>Comments and notes<\/li>\n<\/ul>\n<p>Workbook Statistics:<\/p>\n<ul>\n<li>Number of sheets<\/li>\n<li>Cells with data<\/li>\n<li>Tables and PivotTables<\/li>\n<li>Formulas<\/li>\n<li>Charts<\/li>\n<li>External connections<\/li>\n<li>Macros<\/li>\n<\/ul>\n<p>You can view Workbook Statistics in Excel for Microsoft 365 on Windows and Mac as well as in Excel on the web. You can also access it in the same way on these platforms. The only difference is that <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/check-workbook-statistics-afa12d4b-9584-4826-99a8-33228467e006\">Excel online does not display the complete data lists<\/a>\u00a0written above for sheets and workbooks.<\/p>\n<\/div>\n<p><!-- .entry-content --><br \/>\n<!-- .entry-footer --><\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/724325\/how-to-get-workbook-statistics-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Get Workbook Statistics in Microsoft Excel&#8221; When you need 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. Here\u2019s how it works. Viewing statistics in Microsoft Word is helpful for seeing the number of pages, words,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":251623,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-251622","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/251622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=251622"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/251622\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/251623"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=251622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=251622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=251622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}