{"id":437552,"date":"2022-04-25T18:00:49","date_gmt":"2022-04-25T15:00:49","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-copy-values-from-the-status-bar-in-microsoft-excel\/"},"modified":"2022-04-25T18:00:49","modified_gmt":"2022-04-25T15:00:49","slug":"how-to-copy-values-from-the-status-bar-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-copy-values-from-the-status-bar-in-microsoft-excel\/","title":{"rendered":"#How to Copy Values From the Status Bar in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a3a973ab3ece\" 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-6a3a973ab3ece\" 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-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-values-from-the-status-bar-in-microsoft-excel\/#%E2%80%9CHow_to_Copy_Values_From_the_Status_Bar_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Copy Values From the Status Bar in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-values-from-the-status-bar-in-microsoft-excel\/#Choose_Your_Status_Bar_Calculations\" >Choose Your Status Bar Calculations<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-values-from-the-status-bar-in-microsoft-excel\/#Select_the_Cells_to_View_the_Calculations\" >Select the Cells to View the Calculations<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-copy-values-from-the-status-bar-in-microsoft-excel\/#Copy_the_Status_Bar_Values\" >Copy the Status Bar Values<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Copy_Values_From_the_Status_Bar_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Copy Values From the Status Bar in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The Status Bar in Microsoft Excel allows you to quickly see the average, sum, or count of selected cells. But what\u2019s better than viewing those values is being able to use them. Here\u2019s how copy directly from the Status Bar.<\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> As of this writing in April 2022, the ability to copy values from the Status Bar is slowly <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/insider.office.com\/en-us\/blog\/copy-values-quickly-from-the-status-bar-in-excel-for-windows?ocid=PROD_Core_CONS_OIP_USG_OINews0322\">rolling out to Excel on Windows users<\/a> beginning with Office Insiders. So if you don\u2019t see the feature yet, you should soon.<\/p><\/blockquote>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Choose_Your_Status_Bar_Calculations\"><\/span>Choose Your Status Bar Calculations<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Because you can customize the elements that <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ear in the Excel Status Bar, you\u2019ll need to confirm that those you want to view and copy are selected.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Customize and Use the Status Bar in Excel<\/em><\/strong><\/p>\n<p>Right-click the Status Bar in Excel to see the available items. Those with checkmarks are the ones visible in the Status Bar. So if you want to see the average, for example, be sure to select it to place that checkmark next to it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795251\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/SelectedValues-ExcelStatusBarCopy.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Status Bar selected calculations\" width=\"650\" height=\"295\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" 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=\"Select_the_Cells_to_View_the_Calculations\"><\/span>Select the Cells to View the Calculations<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Calculations like average, sum, minimum, maximum, and others only display in the Status Bar when they apply. This means you\u2019ll need to select the cells in your sheet to show those calculations.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Calculate Average in Microsoft Excel<\/em><\/strong><\/p>\n<p>Select a range of cells and when you look down to the Status Bar, you\u2019ll see the values for the calculations you\u2019ve selected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795252\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Values-ExcelStatusBarCopy.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Status Bar calculations\" width=\"650\" height=\"253\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" 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=\"Copy_the_Status_Bar_Values\"><\/span>Copy the Status Bar Values<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you select the cells and see the calculations at the bottom, simply click the value you want\u00a0in the Status Bar. This places it on your clipboard. You can then paste it directly in your sheet or another application.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Paste Text Without Formatting Almost Anywhere<\/em><\/strong><\/p>\n<p>To paste it into your spreadsheet, select the cell where you want the value and then do one of the following:<\/p>\n<ul>\n<li>Right-click and choose \u201cPaste.\u201d<\/li>\n<li>Go to the Home tab and click \u201cPaste\u201d in the Clipboard section of the ribbon.<\/li>\n<li>Use the keyboard shortcut Ctrl+V.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795253\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Paste-ExcelStatusBarCopy.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Paste a Status Bar value\" width=\"338\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Sometimes small updates to applications we use daily like Microsoft Excel are the best kind. This handy feature allows you to add calculations to your spreadsheets easier than ever before.<\/p>\n<\/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\/795249\/how-to-copy-values-from-the-status-bar-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Copy Values From the Status Bar in Microsoft Excel&#8221; The Status Bar in Microsoft Excel allows you to quickly see the average, sum, or count of selected cells. But what\u2019s better than viewing those values is being able to use them. Here\u2019s how copy directly from the Status Bar. Note: As of this&#8230;<\/p>\n","protected":false},"author":1,"featured_media":437553,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-437552","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\/437552","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=437552"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/437552\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/437553"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=437552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=437552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=437552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}