{"id":5171,"date":"2018-04-27T09:49:17","date_gmt":"2018-04-27T02:49:17","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/"},"modified":"2023-10-24T13:23:10","modified_gmt":"2023-10-24T06:23:10","slug":"huong-dan-han-che-quyen-truy-cap-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/","title":{"rendered":"Instructions to restrict access in Google Sheets"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">The rights and security of users&#039; data access is the first philosophy Google aims to when building their services, that for the 3 Google Docs, Sheets, Slide applications is even more placed on the top. .\u00a0<\/span><span style=\"font-weight: 400;\">You may be familiar with how to use the limited Editing, View, and Comment functions on documents, today&#039;s article will introduce you to more advanced &quot;security rules&quot;, in order to <strong>Restrict access<\/strong> that Google has integrated into their products \u2013 functions that will help you achieve the highest level of security management.<\/span><\/p>\n<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\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/#Phan_1_Nhung_chuc_nang_han_che_quyen_truy_cap_nang_cao_khi_chia_se_bat_ki_tai_lieu_tren_Drive\" >Part 1: Advanced access restrictions when sharing any document on Drive.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/#Buoc_1\" >Step 1:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/#Buoc_2\" >Step 2:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/#Buoc_3\" >Step 3:<\/a><\/li><\/ul><\/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\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/#Phan_2_Bao_ve_du_lieu_cua_Google_Sheets_khi_chia_se_file_cho_nguoi_khac\" >Part 2: Protect Google Sheets data when sharing files with others<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/#Chu_y\" >Attention:<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Phan_1_Nhung_chuc_nang_han_che_quyen_truy_cap_nang_cao_khi_chia_se_bat_ki_tai_lieu_tren_Drive\"><\/span><span style=\"font-size: 18pt;\"><b>Part 1: Advanced access restrictions when sharing any document on Drive. <\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_1\"><\/span><b>Step 1<\/b><span style=\"font-weight: 400;\">: <\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">You access your Google Drive, select a data file that you want to set access rights, in the right hand corner, click on the item. <\/span><b>Share<\/b><span style=\"font-weight: 400;\">, in the new window, select <\/span><b>Advanced<\/b><span style=\"font-weight: 400;\"> bottom right corner:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17287 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2017\/08\/Google-drive-chia-se-file.jpg\" alt=\"Instructions for restricting access in Google Sheets 1\" width=\"695\" height=\"350\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_2\"><\/span><span style=\"font-weight: 400;\"><strong>Step 2:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> After typing the gmail address that you want to share the View, Edit, Comment permission, you can check the box:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><i><span style=\"font-weight: 400;\">Prevent editors from changing access and adding new people<\/span><\/i><span style=\"font-weight: 400;\">: If you want <em><strong>editor<\/strong> \u2013 with whom you share editing rights<\/em>\u00a0\u2013 this document cannot be changed or automatically shared with others.<\/span><\/li>\n<li style=\"font-weight: 400;\"><i><span style=\"font-weight: 400;\">Disable options to download, print, and copy for commenter and viewers<\/span><\/i><span style=\"font-weight: 400;\">: If you want to whom you share the rights <em><strong>Comment<\/strong> (Comment)<\/em> or <em><strong>View<\/strong> (Document Viewer)<\/em> this data cannot be downloaded, printed or copied.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17288\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2017\/08\/google-drive-chia-se-quyen-su-dung-1024x665.png\" alt=\"Instructions for restricting access in Google Sheets 2\" width=\"818\" height=\"531\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_3\"><\/span><span style=\"font-weight: 400;\"><strong>Step 3:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> After selecting, you click <em><strong>Done<\/strong><\/em> to complete the installation<\/span><\/p>\n<h2><\/h2>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Phan_2_Bao_ve_du_lieu_cua_Google_Sheets_khi_chia_se_file_cho_nguoi_khac\"><\/span><span style=\"font-size: 18pt;\"><b>Part 2: Protect Google Sheets data when sharing files with others<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sometimes you need to make sure the data you have entered into Google Sheets is not changed by the people it is shared with, which can seem really difficult when giving them permission.\u00a0<em><strong>Edit<\/strong><\/em>. Don&#039;t worry, Google always listens to user feedback and adds functionality <em><strong>Protect sheet<\/strong><\/em> to deal with that problem.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-weight: 400;\">Find the function <\/span><em><b>Protect sheet <\/b><\/em><span style=\"font-weight: 400;\">in<\/span><em><b> Tools<\/b><\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17291 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/04\/Google-sheet-protect-sheet.png\" alt=\"Instructions for restricting access in Google Sheets 3\" width=\"625\" height=\"504\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-weight: 400;\"><em><strong>Sheet<\/strong><\/em> or <em><strong>Range<\/strong><\/em> will be the place to lock the edit permissions you require: <\/span>\n<ul>\n<li><em><strong>Enter a desciprtion<\/strong><\/em>: Give a name\/description to explain the scope to which you want to restrict editing.<\/li>\n<li><span style=\"font-weight: 400;\">If you want others to edit only in a certain sheet, click on the box <strong>Sheet<\/strong> right; or just want them to edit within a certain range, then select the cell <strong>Range<\/strong> left side<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17292\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/04\/cho-phep-chinh-sua-1-pham-trong-Google-sheet-1024x593.jpg\" alt=\"Instructions for restricting access in Google Sheets 4\" width=\"710\" height=\"411\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Chu_y\"><\/span><strong>Attention<\/strong>:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>If in your Google Sheets file there are many Sheets, you must select the sheet that you want to set access rights (Sheet 1, Sheet 2, ...) by selecting the cell with the down arrow below.<\/li>\n<li>Please click on the box <em><strong>Except certain cells<\/strong><\/em> if you allow others to edit a Sheet but don&#039;t want them to edit certain cells in that sheet. After choosing <em><strong>Except certain cells<\/strong><\/em>, you can select multiple columns\/rows that cannot be edited by others.<\/li>\n<li>Click on the trash can icon in the right corner if you want to delete the settings you just created.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6701 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/04\/GG-Sheets.png\" alt=\"Instructions for restricting access in Google Sheets 5\" width=\"249\" height=\"312\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Then you choose <em><strong>Set permission<\/strong><\/em><\/li>\n<li>You can then install in more detail:\n<ul>\n<li>Choose <em><strong>Show a warning when editing this range<\/strong><\/em>: Display a warning when someone wants to edit these sheets\/ranges<\/li>\n<li><em><strong>Restrict who can edit this range<\/strong><\/em>: If you have shared the edit permission for the whole file to many people, who can edit the cells you want. Select the down arrow in the box below: Select <em><strong>Only you<\/strong><\/em> if you want only you to have the right to edit, or choose <em><strong>Custom<\/strong><\/em> and click on the members you allow editing.<\/li>\n<li>Choose <em><strong>Add an editor<\/strong><\/em>: Add someone with edit permission and enter their email address.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6703\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/04\/Capture.png\" alt=\"Restrict access 6\" width=\"600\" height=\"398\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Once done, you can press <em><strong>Done<\/strong><\/em> to complete.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">With the above operations, you can be somewhat secure when sharing documents with others. However, if you are working in a company and want to ensure that your business data is circulated only within the enterprise and protected from unauthorized access from people outside the public domain, company, you can learn more about the G Suite suite of solutions (including<strong> google email <\/strong>According to the company domain name, Google Drive stores and shares information, video conference, etc.) \u2013 a suite of applications exclusively for Google&#039;s businesses. With G Suite, security doesn&#039;t just stop at restricting access to documents, you can completely build a <strong><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/email-cho-doanh-nghiep-g-suite-hay-mail-hosting\/\">Privacy Policy<\/a><\/strong> more about the email flow of employees in the company.<\/p>\n<p style=\"text-align: right;\"><strong>Updated: Gimasys<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>You may be familiar with using the limited functions of Editing, Viewing, and Commenting on documents. Today&#039;s article will introduce to you more advanced &quot;security rules&quot; that Google has integrated into its products. them, functions that will help you achieve the highest level of security management.<\/p>","protected":false},"author":1,"featured_media":5172,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-5171","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5171","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=5171"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5171\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5172"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}