{"id":289255,"date":"2021-07-01T17:24:00","date_gmt":"2021-07-01T14:24:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-see-the-edit-history-of-a-cell-in-google-sheets\/"},"modified":"2021-07-01T17:24:00","modified_gmt":"2021-07-01T14:24:00","slug":"how-to-see-the-edit-history-of-a-cell-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-see-the-edit-history-of-a-cell-in-google-sheets\/","title":{"rendered":"#How to See the Edit History of a Cell in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 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-6b007fa14470b\" 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-6b007fa14470b\" 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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-see-the-edit-history-of-a-cell-in-google-sheets\/#What_You_Can_See_in_a_Cells_Edit_History\" >What You Can See in a Cell\u2019s Edit History<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-see-the-edit-history-of-a-cell-in-google-sheets\/#The_Limitations_of_Google_Sheets_Cell_Edit_History_Feature\" >The Limitations of Google Sheets\u2019 Cell Edit History Feature<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-see-the-edit-history-of-a-cell-in-google-sheets\/#How_to_See_the_Edit_History_of_a_Cell_in_Google_Sheets\" >How to See the Edit History of a Cell in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to See the Edit History of a Cell in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-730312\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-logo-black-white-gradient-featured.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets logo with a black-and-white gradient\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Need to check who made changes to a particular cell in Google Sheets? Good <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/news\/\" data-internallinksmanager029f6b8e52c=\"2\" title=\"News\" target=\"_blank\" rel=\"noopener\">news<\/a>: Google Sheets does have a feature that shows you who made changes, along with a time stamp.<\/p>\n<p>If you\u2019re collaborating with multiple people, it can get hard to track every change that\u2019s made to any Google Sheets document. Particularly with massive spreadsheets, going through version history can get a bit tedious if you\u2019re looking for changes made to a specific cell. Viewing a cell\u2019s edit history is a much easier task.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_You_Can_See_in_a_Cells_Edit_History\"><\/span>What You Can See in a Cell\u2019s Edit History<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>It\u2019s good to know what Google considers an edit to a cell. This will help you know what to expect when you check its edit history. There are three types of changes that show up in Google Sheets\u2019 cell edit history:<\/p>\n<ul>\n<li>Changes to the values inside a cell, such as replacing a number with text.<\/li>\n<li>Changes to hyperlinks inside a cell.<\/li>\n<li>Changes to formulas in a cell.<\/li>\n<\/ul>\n<p>Apart from this, you\u2019ll also be able to see who made changes, along with a neat time stamp.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"The_Limitations_of_Google_Sheets_Cell_Edit_History_Feature\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_EditLimits\">The Limitations of Google Sheets\u2019 Cell Edit History Feature<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This feature in Google Sheets has a few minor limitations that you should be aware of. While you can see who\u2019s edited a cell and when they did it, you\u2019ll only be able to see one change at a time. It\u2019s a bit tedious to check for changes made a long time ago.<\/p>\n<p>However, you can always go check the version history of your document to hone in on <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/394496\/how-to-switch-to-an-earlier-version-of-a-google-docs-sheets-or-slides-file\/\">older changes made to the spreadsheet. Do note that some types of changes might not appear in a cell\u2019s edit history, including the following:<\/p>\n<ul>\n<li>Changes to the cell\u2019s format, such as changing a text cell to a date format in Google Sheets.<\/li>\n<li>Changes made by formulas, which means that if you\u2019ve used the sum function and the result changes, you\u2019ll not be able to see the change in value in the cell\u2019s edit history.<\/li>\n<li>Changes related to adding or removing rows and columns.<\/li>\n<\/ul>\n<p><strong>RELATED:<\/strong> <strong><em>How to Switch to an Earlier Version of a Google Docs, Sheets, or Slides File<\/em><\/strong><\/p>\n<p>Another thing to remember is that this feature will only show you the edit history. You can\u2019t use this to restore older versions of data in any given cell.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_See_the_Edit_History_of_a_Cell_in_Google_Sheets\"><\/span>How to See the Edit History of a Cell in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Now that we know what we can and can\u2019t see while checking a cell\u2019s edit history in Google Sheets, let\u2019s check out how to use this feature. In Google Sheets, right-click any cell and select \u201cShow edit history.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730307\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-edit-history-show.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click any cell and click Show edit history\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If the cell is empty and no changes were made, you\u2019ll see a pop-up that reads \u201cNo edit history.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730310\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-no-edit-history.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"If you haven't made any changes to a cell in Google Sheets, you'll see a pop-up with the message &quot;No edit history&quot;\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/730304\/how-to-see-the-edit-history-of-a-cell-in-google-sheets\/#moka_anchor_WhatsInAnEdit\">edits were made to the cell, you\u2019ll see a pop-up showing the name of the person who made the change, a time stamp, and details concerning the change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730306\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-edit-history-popup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The edit history of a cell in Google Sheets\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the left arrow at the top of the pop-up to see older changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730308\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-edit-history-left-arrow.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the left arrow to see older changes to a cell in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can hit the right arrow at the top to see newer changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-730309\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-edit-history-right-arrow.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the right arrow to see newer changes to a cell in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If your change\u00a0isn\u2019t showing up in edit history, you need to check whether it\u2019s one of those changes that don\u2019t show up here. And for a more detailed log of changes made to your spreadsheet in Google Sheets, you should check its version history.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to See Recent Changes to Your Google Docs, Sheets, or Slides File<\/em><\/strong><\/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\/730304\/how-to-see-the-edit-history-of-a-cell-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to See the Edit History of a Cell in Google Sheets&#8221; Need to check who made changes to a particular cell in Google Sheets? Good news: Google Sheets does have a feature that shows you who made changes, along with a time stamp. If you\u2019re collaborating with multiple people, it can get hard to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":289256,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-logo-black-white-gradient-featured.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-289255","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\/289255","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=289255"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/289255\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/289256"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=289255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=289255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=289255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}