{"id":5966,"date":"2019-07-12T10:48:39","date_gmt":"2019-07-12T03:48:39","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/xem-lich-su-chinh-sua-cua-mot-o-trong-google-sheet\/"},"modified":"2023-05-10T14:16:42","modified_gmt":"2023-05-10T07:16:42","slug":"view-the-edit-history-of-a-cell-in-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/view-the-edit-history-of-a-cell-in-sheets\/","title":{"rendered":"View the edit history of a cell in Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" 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: #999;color:#999\" 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><\/span><\/a><\/span><\/div>\n<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:\/\/gcloudvn.com\/en\/kienthuc\/view-the-edit-history-of-a-cell-in-sheets\/#Cai_gi_thay_doi\" >What\u2019s changing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/view-the-edit-history-of-a-cell-in-sheets\/#Ai_bi_anh_huong\" >Who\u2019s impacted\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/view-the-edit-history-of-a-cell-in-sheets\/#Tai_sao_ban_nen_dung_no\" >Why you\u2019d use it<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/view-the-edit-history-of-a-cell-in-sheets\/#Bat_dau_nhu_the_nao\" >How to get started\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/view-the-edit-history-of-a-cell-in-sheets\/#Thong_tin_chi_tiet\" >Additional details\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cai_gi_thay_doi\"><\/span><b>What\u2019s changing<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u201cShow edit history\u201d is a new feature in Sheets that will help you easily see the edit history of a cell, including who made the last edit, when that edit was made, and the cell\u2019s previous value.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14404 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2019\/07\/edithistooryflow.gif\" alt=\"View the edit history of a cell in Sheets\" width=\"1600\" height=\"1000\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ai_bi_anh_huong\"><\/span><b>Who\u2019s impacted\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">End users<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_ban_nen_dung_no\"><\/span><b>Why you\u2019d use it<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tracking edits made by collaborators is important for keeping information accurate and understanding why specific changes were made. This is especially critical when there are several collaborators working in a sheet.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Previously, you would need to open up Version History and manually look through past versions of a sheet to determine who changed a cell and when and by whom. With Show edit history, you can quickly surface the edit history of a cell: who edited, when, and the previous value.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau_nhu_the_nao\"><\/span><b>How to get started\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>Admins:<\/b><span style=\"font-weight: 400;\"> No action required<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>End users:<\/b><span style=\"font-weight: 400;\"> To start using Show edit history:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right click on any cell and select \u201cShow edit history\u201d from the dropdown menu.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A dialogue box will appear that will show you:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The user who last made a direct edit in the cell<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A timestamp of the edit<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The previous value and current value of the cell<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Arrow keys in the top right corner which toggle back and forth between edits<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_tin_chi_tiet\"><\/span><b>Additional details\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">The following changes are considered previous edits to a cell:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Adding, editing, or removing content \u2014 like changing the value of a cell from \u201c3\u201d to \u201c5\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Changing a formula \u2014 like changing \u201c=A1+B1\u201d to \u201c=A1+C5\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Adding, editing, or removing a link from a cell<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b><i>Note<\/i><\/b><span style=\"font-weight: 400;\">: Some changes may not show up in the edit history. Some examples are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400; text-align: justify;\"><span style=\"font-weight: 400;\">Added or deleted rows and columns<\/span><\/li>\n<li style=\"font-weight: 400; text-align: justify;\"><span style=\"font-weight: 400;\">Changes to the cell\u2019s format<\/span><\/li>\n<li style=\"font-weight: 400; text-align: justify;\"><span style=\"font-weight: 400;\">Changes made by formulas<\/span><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Source: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>C\u00e1i g\u00ec thay \u0111\u1ed5i L\u1ecbch s\u1eed ch\u1ec9nh s\u1eeda c\u1ee7a Xem L\u1ecbch s\u1eed l\u00e0 m\u1ed9t t\u00ednh n\u0103ng m\u1edbi trong Sheets s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng xem l\u1ecbch s\u1eed ch\u1ec9nh s\u1eeda c\u1ee7a m\u1ed9t \u00f4, bao g\u1ed3m c\u1ea3 ng\u01b0\u1eddi th\u1ef1c hi\u1ec7n ch\u1ec9nh s\u1eeda&hellip;<\/p>","protected":false},"author":1,"featured_media":5967,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5966","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=5966"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5966\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5967"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}