{"id":4542,"date":"2017-03-13T15:52:12","date_gmt":"2017-03-13T08:52:12","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/duong-dan-o-o-trong-google-sheets\/"},"modified":"2023-10-23T13:40:34","modified_gmt":"2023-10-23T06:40:34","slug":"duong-dan-o-o-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/duong-dan-o-o-trong-google-sheets\/","title":{"rendered":"How To View Edit History And Create Paths In Cells In Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 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\/duong-dan-o-o-trong-google-sheets\/#Chen_duong_dan_o_o_cu_the_trong_Google_Sheets\" >Insert path in specific cell in Google Sheets<\/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\/duong-dan-o-o-trong-google-sheets\/#Tinh_nang_xem_lich_su_chinh_sua_trong_Google_Sheets\" >View edit history in Google Sheets<\/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\/duong-dan-o-o-trong-google-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-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/duong-dan-o-o-trong-google-sheets\/#Tai_sao_ban_nen_dung_tinh_nang_xem_lich_su_cua_Google_Sheets\" >Why You Should Use Google Sheets History Viewer<\/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\/duong-dan-o-o-trong-google-sheets\/#Cach_su_dung_xem_lich_su_chinh_sua\" >How to use view edit history\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/duong-dan-o-o-trong-google-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=\"Chen_duong_dan_o_o_cu_the_trong_Google_Sheets\"><\/span>Insert path in specific cell in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">It is often difficult for users to navigate complex and large spreadsheets, that&#039;s why Google has introduced inserting paths in specific cells in Google sheets.<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">With this new feature, users can create \u201ctables of content\u201d for spreadsheets, navigate to specific content in the spreadsheet, and still retain the path in cells when you export spreadsheets from other applications. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To insert the paths in the cells in the spreadsheet, select &quot;Insert link&quot; &gt; Select a range of cells to link&quot;.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4464 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2017\/03\/Link-to-cells-1.png\" alt=\"insert the link in the google sheets box\" width=\"451\" height=\"256\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_nang_xem_lich_su_chinh_sua_trong_Google_Sheets\"><\/span><span style=\"font-weight: 400;\"><b>View edit history in Google Sheets<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">View History&#039;s edit history is a new feature in Sheets that makes it easy to see the edit history of a cell, including who made the last edit, when it was made, and the value previous of the cell. Learn about features <a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/\">restrict access in Google Sheets<\/a>.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14404\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2019\/07\/edithistooryflow.gif\" alt=\"view edit history in google sheets\" width=\"700\" height=\"438\" \/><\/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_tinh_nang_xem_lich_su_cua_Google_Sheets\"><\/span><b>Why You Should Use Google Sheets History Viewer<\/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=\"Cach_su_dung_xem_lich_su_chinh_sua\"><\/span><b>How to use view edit history\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 style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Added or deleted rows and columns<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Changes to the cell\u2019s format<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Changes made by formulas<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Present <a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-doi-ten-bo-ung-dung-g-suite-thanh-google-workspace\/\">G Suite has changed its name to Google Workspace<\/a>\u00a0with many new features. Please contact Gimasys today to update the latest features.<\/p>\n<p style=\"text-align: right;\"><strong>Source: <a href=\"https:\/\/gcloudvn.com\/en\/\" target=\"_blank\" rel=\"noopener noreferrer\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google introduces inserting a link in a specific cell in Google sheets.<\/p>","protected":false},"author":1,"featured_media":4543,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4542","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\/4542","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=4542"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/4542\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/4543"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=4542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=4542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=4542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}