{"id":507724,"date":"2022-11-07T23:00:50","date_gmt":"2022-11-07T20:00:50","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-show-changes-in-microsoft-excel-on-desktop\/"},"modified":"2022-11-07T23:00:50","modified_gmt":"2022-11-07T20:00:50","slug":"how-to-show-changes-in-microsoft-excel-on-desktop","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-show-changes-in-microsoft-excel-on-desktop\/","title":{"rendered":"#How to Show Changes in Microsoft Excel on Desktop"},"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-6a3a120331451\" 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-6a3a120331451\" 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-show-changes-in-microsoft-excel-on-desktop\/#%E2%80%9CHow_to_Show_Changes_in_Microsoft_Excel_on_Desktop%E2%80%9D\" >&#8220;How to Show Changes in Microsoft Excel on Desktop&#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-show-changes-in-microsoft-excel-on-desktop\/#What_Changes_Can_You_See\" >What Changes Can You See?<\/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-show-changes-in-microsoft-excel-on-desktop\/#How_to_Show_Changes_in_Excel\" >How to Show Changes in Excel<\/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-show-changes-in-microsoft-excel-on-desktop\/#Use_a_Filter_to_Show_Changes\" >Use a Filter to Show Changes<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Show_Changes_in_Microsoft_Excel_on_Desktop%E2%80%9D\"><\/span>&#8220;How to Show Changes in Microsoft Excel on Desktop&#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-no-defer=\"\" 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\"\/><\/p>\n<p>Launch the &#8220;Show Changes&#8221; tool from the Review tab on the ribbon to view a list of changes along with the user that made them. You can also filter these changes to look for only specific changes.<\/p>\n<p>Do you see something unusual in your Excel spreadsheet? Wondering how the change may have h<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>ened? Whether you\u2019re working with others or alone on an Excel sheet, there\u2019s a simple way to see the changes that take place.<\/p>\n<p>With the click of a button, you can view the changes in a workbook for each sheet. You can see who made the edit, when they made it, and exactly what changed.<\/p>\n<p>This feature was first made\u00a0available in Excel for the web but was later added to the Excel desktop application on Windows and Mac for Microsoft 365 subscribers.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"What_Changes_Can_You_See\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">What Changes Can You See?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>With the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/get-help-with-show-changes-in-excel-a1493bf9-25c3-470a-b970-60eceb0136e5\">Show Changes feature<\/a>, you can see edits to cell values and formulas for up to 60 days. This includes changes involving moving, sorting, inserting, and deleting. However, you can\u2019t see changes to charts, shapes, objects, pivot table operations, formatting, hidden cells, filtering, or deleted locations.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Show_Changes_in_Excel\"><\/span>How to Show Changes in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Open your Excel workbook, go to the Review tab, and select \u201cShow Changes\u201d in the Changes section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-834830\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ReviewShowChanges-ExcelShowChangesDesktop.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Show Changes on the Review tab in Excel\" width=\"493\" height=\"156\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see a panel open on the right side with a list of <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/728563\/how-to-view-version-history-in-microsoft-excel-online\/\">changes for the workbook. You\u2019ll see the person who made the change with the date and time.<\/p>\n<p>You can then review the sheet, item, and cell that was edited.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-834829\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ShowChangesSidebar-ExcelShowChangesDesktop.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Show Changes panel in Excel\" width=\"650\" height=\"317\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To see the change in the sheet, select the cell reference, sheet name, or edit icon (pencil) in the box for the change in the sidebar. You\u2019ll then see the changed item highlighted in the sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-834828\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/HighlightChange-ExcelShowChangesDesktop.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Highlighted cell that was changed\" width=\"650\" height=\"318\" 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=\"Use_a_Filter_to_Show_Changes\"><\/span>Use a Filter to Show Changes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By default, you\u2019ll see all the\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/725268\/how-to-view-and-restore-previous-versions-of-excel-workbooks\/\">changes to a workbook when you click the Show Changes button. But you can also filter the list to view a specific sheet or range of cells.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to View and Restore Previous Versions of Excel Workbooks<\/em><\/strong><\/p>\n<p>With the Show Changes sidebar open, select the filter drop-down arrow at the top. You can move your cursor to Sheet and then pick a particular spreadsheet in the pop-out menu to view only those changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-834827\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FilterSheet-ExcelShowChangesDesktop.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Filter by sheet for Show Changes\" width=\"337\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also choose \u201cRange\u201d to see changes to certain cells.<\/p>\n<p>Enter the cell range (with the sheet name) in the box to the right or select the cells on the sheet to populate the Range box. Then, click the green arrow to view those changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-834826\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FilterRange-ExcelShowChangesDesktop.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Filter by range for Show Changes\" width=\"612\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish using the filters, select \u201cClear Filter\u201d in the drop-down menu. The panel then shows the entire list of changes again.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-834825\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ClearFilter-ExcelShowChangesDesktop.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Clear Filter in the Show Changes Filter menu\" width=\"363\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Seeing the changes you or your collaborators make in Excel is easier than ever. Be sure to keep this guide bookmarked for future use.<\/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\/834823\/how-to-show-changes-in-microsoft-excel-on-desktop\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Show Changes in Microsoft Excel on Desktop&#8221; Launch the &#8220;Show Changes&#8221; tool from the Review tab on the ribbon to view a list of changes along with the user that made them. You can also filter these changes to look for only specific changes. Do you see something unusual in your Excel spreadsheet?&#8230;<\/p>\n","protected":false},"author":1,"featured_media":507725,"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-507724","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\/507724","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=507724"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/507724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/507725"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=507724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=507724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=507724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}