{"id":292700,"date":"2021-07-06T17:24:33","date_gmt":"2021-07-06T14:24:33","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-check-version-history-in-google-sheets\/"},"modified":"2021-07-06T17:24:33","modified_gmt":"2021-07-06T14:24:33","slug":"how-to-check-version-history-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-check-version-history-in-google-sheets\/","title":{"rendered":"#How to Check Version History in Google Sheets"},"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-6a25b5bf4e2c9\" 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-6a25b5bf4e2c9\" 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-check-version-history-in-google-sheets\/#How_to_Check_Version_History_in_Google_Sheets\" >How to Check Version History in Google Sheets<\/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-check-version-history-in-google-sheets\/#How_to_Add_Version_Names_in_Google_Sheets\" >How to Add Version Names in Google Sheets<\/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-check-version-history-in-google-sheets\/#How_to_Restore_Old_Versions_of_Spreadsheets_in_Google_Sheets\" >How to Restore Old Versions of Spreadsheets in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Check Version History in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google Sheets maintains a detailed version history of all the changes or edits you\u2019ve made to your spreadsheets. Here\u2019s how to check your edit log, add version names, and restore them when necessary.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Check_Version_History_in_Google_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_CheckVersionHistory\">How to Check Version History in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>First, open your browser and visit the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets website<\/a>, and then load the spreadsheet that you want to work on. If you\u2019ve opened up a new spreadsheet, be sure to make a few edits so that Google Sheets has some edit history to log.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>The Beginner&#8217;s Guide to Google Sheets<\/em><\/strong><\/p>\n<p>Once you\u2019ve done that, there are two ways to check version history in Google Sheets. The simplest is to click the \u201cLast Edit Was At\u201d link to the right of the \u201cHelp\u201d button in the menu bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731660\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-last-edit.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;last edit&quot; link in the menu bar.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Alternatively, in Google Sheets, you can navigate to File &gt; Version History in the menu bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731659\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-file-version-history.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In Google Sheets, you can go to File &gt; Version History to view older versions of your spreadsheet.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cVersion History\u201d menu, select \u201cSee Version History.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731658\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-see-version-history.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;See Version History&quot; to view older versions of your Google Sheets spreadsheet.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This will show you a detailed log of all the changes made to your spreadsheet. You can see this in a pane on the right-hand side of the page.\u00a0Google helpfully groups these changes by date and also time, which makes it easy to zero in on specific sets of edits to the spreadsheet. You can click any of the timestamps to go to that version.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731655\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-expand-version-history-group.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The expanded version history view in Google Sheets.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To see more versions under any version group, click the small triangular arrow icon, which is located to the left of the timestamp in the version history pane.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731656\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-expand-version-history.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After you click the triangle, the menu will expand, revealing a bunch of entries from the version history that should help you find the exact version you\u2019re looking for.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731655\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-expand-version-history-group.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The expanded version history view in Google Sheets.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Add_Version_Names_in_Google_Sheets\"><\/span>How to Add Version Names in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Checking version history can quickly get tedious because of the version-naming scheme. Google Sheets names each version with a timestamp, which is a good starting point, but it can get overwhelming on documents with lots of changes.<\/p>\n<p>That\u2019s why it\u2019s a good idea to name specific versions of documents in Google Sheets. We\u2019re not suggesting that you diligently rename every minor change\u2014that\u2019s even more cumbersome\u2014but it\u2019s helpful to tag versions with big changes.<\/p>\n<p>You can easily do this by opening the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/731648\/how-to-check-version-history-in-google-sheets\/#moka_anchor_CheckVersionHistory\">version history of any spreadsheet in Google Sheets and then clicking the three-dot icon next to the version that you want to name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731670\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-more-actions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the menu that appears, click \u201cName This Version,\u201d and Google Sheets will allow you to change the version\u2019s name from a timestamp to whatever you wish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731668\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-name-this-version.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Name This Version&quot; to rename a version of your spreadsheet in Google Sheets.\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you\u2019re done, hit the Enter key or click anywhere else on the spreadsheet to confirm the name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731667\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-named-version.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A named version of a spreadsheet in Google Sheets.\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After naming all of the versions that are important, you can make Google Sheets highlight only named versions of a spreadsheet while checking its version history. This helps you find versions with big changes quickly, without having to go through multiple sets of timestamps.<\/p>\n<p>To do this, open the version history pane in Google Sheets once more. At the top of this pane, just below the \u201cVersion History\u201d label, you can enable the option called \u201cOnly Show Named Versions.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731669\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-show-named-versions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enable &quot;Show Named Versions&quot; to hide all versions with just time stamps for names in Google Sheets.\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This will highlight only the versions that you\u2019ve named, along with the most recent version of your spreadsheet.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Restore_Old_Versions_of_Spreadsheets_in_Google_Sheets\"><\/span>How to Restore Old Versions of Spreadsheets in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Now that you\u2019ve found the version history of your spreadsheet and learned how to name the versions, it\u2019s time to learn how to restore old versions in Google Sheets. To do this, open the version history pane in Google Sheets and select the correct version of the spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731667\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-named-version.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A named version of a spreadsheet in Google Sheets.\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The next step is to click the big green button called \u201cRestore This Version,\u201d which is located at the top of the page.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731674\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-restore-this-version-green.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the big green button called &quot;Restore This Version,&quot; which is located at the top of the page in Google Sheets.\" width=\"650\" height=\"200\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also go to the version history pane on the right and click the three-dot icon next to the name of the version. Here, select \u201cRestore This Version.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731675\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-version-history-restore-this-version.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Restore this Version&quot; from the menu.\" width=\"650\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Both methods lead to the same end result\u2014restoring the old version of a spreadsheet in Google Sheets. With that done, you might enjoy reading about how to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/709525\/how-to-delete-version-history-in-google-docs\/\">delete version history in Google Docs.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Delete Version History in Google Docs<\/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\/731648\/how-to-check-version-history-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Check Version History in Google Sheets&#8221; Google Sheets maintains a detailed version history of all the changes or edits you\u2019ve made to your spreadsheets. Here\u2019s how to check your edit log, add version names, and restore them when necessary. How to Check Version History in Google Sheets First, open your browser and visit&#8230;<\/p>\n","protected":false},"author":1,"featured_media":292701,"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_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-292700","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\/292700","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=292700"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/292700\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/292701"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=292700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=292700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=292700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}