{"id":7071,"date":"2017-11-13T10:57:41","date_gmt":"2017-11-13T09:57:41","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=7071"},"modified":"2017-11-13T10:57:41","modified_gmt":"2017-11-13T09:57:41","slug":"proteger-des-cellules-ou-des-pages-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/protect-cells-or-pages-in-google-sheets\/","title":{"rendered":"Comment prot\u00e9ger des cellules ou des pages dans Google Sheets ?"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

With the advent of the Internet and cloud-based technology, collaboration and information exchange have become a breeze.\u00a0<\/span>Google Sheets<\/a>\u00a0<\/span>has been the leader in the spreadsheets space. As easy as it has become to work on these ubiquitous applications, it is equally secure the data on the Google Sheets files. This article explains the procedure to\u00a0protect cells or pages in Google Sheets.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Why protect cells or pages in Google Sheets?<\/h3>\n

Most of us use Google Sheets because of the ease with which we can share the spreadsheet files with others. While this has made our work life easier, it also comes with certain concerns. Let us consider an example. A VP of sales in a retail store chain wants to have the sales figures from all the regions in one spreadsheet. Accordingly, he has shared the file to his sales team where each sales manager inputs the sales data corresponding to his\/her region. A summary sheet consolidates the data into one place, where he gets to compare the performance across regions.<\/p>\n

While all of this is in place, the VP doesn\u2019t want his sales team to accidentally manipulate any formulas or numbers on the summary sheet. This scenario definitely calls for a solution that can protect cells or pages in Google Sheets. We explain how to do this below. Here\u2019s how the summary sheet looks like.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/protect-cells-in-Google-Sheets-1.png” alt=”protect cells in Google Sheets 1″ title_text=”protect cells in Google Sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

The VP is looking to protect the cells A1 through C4 which contain information that should not be changed. To do so, we navigate to\u00a0<\/span>Data > Protected sheets and ranges<\/strong>.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/protect-cells-in-Google-Sheets-2.png” alt=”protect cells in Google Sheets 2″ title_text=”protect cells in Google Sheets 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

In doing so, we see sidebar on the right side of the screen. Now we click on the Add sheet or range<\/strong>\u00a0button.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/protect-cells-in-Google-Sheets-3.png” alt=”protect cells in Google Sheets 3″ title_text=”protect cells in Google Sheets 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Now, we give a description of our choice to explain what this means if we ever came back to it in the future. We ensure that\u00a0<\/span>Range<\/g><\/strong>\u00a0<\/span>button is clicked and the corresponding field shows\u00a0\u2018All Regions\u2019!A1:C4<\/g><\/strong>.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/protect-cells-in-Google-Sheets-4.png” alt=”protect cells in Google Sheets 4″ title_text=”protect cells in Google Sheets 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Now we click on the\u00a0<\/span>Set permissions<\/strong>\u00a0<\/span>button. On the options window that pops us, we can set the permissions of our choice. We may either choose to just configure it to show a warning message when another user tries to change a protected cell. Or, we can set it so that no one can edit these cells. Or even set a custom list of users who can edit the cells. In this case, we leave it as shown in the image below. Finally, we click on the\u00a0<\/span>Done<\/strong>\u00a0<\/span>button.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/protect-cells-in-Google-Sheets-5.png” alt=”protect cells in Google Sheets 5″ title_text=”protect cells in Google Sheets 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Now, what happens when another user tries to edit one of these protected cells? Here\u2019s how it prevents them.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/protect-cells-in-Google-Sheets-6.png” alt=”protect cells in Google Sheets 6″ title_text=”protect cells in Google Sheets 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

There can be other instances when we want to protect an entire sheet or almost all of it. In this case, we can opt for the Sheet button as shown in the image below. We can even exempt cells that we do not want to protect from the protected sheet.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/protect-cells-in-Google-Sheets-7.png” alt=”protect cells in Google Sheets 7″ title_text=”protect cells in Google Sheets 7″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

This is how you protect cells or pages in Google Sheets! Feel free to read the following blog posts and learn how to <\/span>only temporarily share your spreadsheet data with others <\/a>or how to name ranges or cells in Google Sheets.<\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

With the advent of the Internet and cloud-based technology, collaboration and information exchange have become a breeze.\u00a0Google Sheets\u00a0has been the leader in the spreadsheets space. As easy as it has become to work on these ubiquitous applications, it is equally secure the data on the Google Sheets files. This article explains the procedure to\u00a0protect cells […]<\/p>\n","protected":false},"author":40,"featured_media":7072,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"

With the advent of the Internet and cloud-based technology, collaboration and information exchange have become a breeze. Google Sheets has been the leader in the spreadsheets space. As easy as it has become to work on these ubiquitous applications, it is equally secure the data on the Google Sheets files. This article explains the procedure to\u00a0protect cells or pages in Google Sheets.<\/p>

Why protect cells or pages in Google Sheets?<\/h3>

Most of us use Google Sheets because of the ease with which we can share the spreadsheet files with others. While this has made our work life easier, it also comes with certain concerns. Let us consider an example. A VP of sales in a retail store chain wants to have the sales figures from all the regions in one spreadsheet. Accordingly, he has shared the file to his sales team where each sales manager inputs the sales data corresponding to his\/her region. A summary sheet consolidates the data into one place, where he gets to compare the performance across regions.<\/p>

While all of this is in place, the VP doesn't want his sales team to accidentally manipulate any formulas or numbers on the summary sheet. This scenario definitely calls for a solution that can protect cells or pages in Google Sheets. We explain how to do this below. Here's how the summary sheet looks like.<\/p>

Example<\/strong> \"Protect<\/p>

The VP is looking to protect the cells A1 through C4 which contain information that should not be changed. To do so, we navigate to Data > Protected sheets and ranges<\/strong>.<\/p>

Example<\/strong> \"Protect[\/panel]<\/p>

In doing so, we see sidebar on the right side of the screen. Now we click on the 'Add sheet or range<\/strong>' button.<\/p>

Example<\/strong> \"Protect<\/p>

Now, we give a description of our choice to explain what this means if we ever came back to it in the future. We ensure that Range<\/strong> button is clicked and the corresponding field shows\u00a0'All Regions'!A1:C4<\/strong>.<\/p>

Example<\/strong> \"Protect<\/p>

Now we click on the Set permissions<\/strong> button. On the options window that pops us, we can set the permissions of our choice. We may either choose to just configure it to show a warning message when another user tries to change a protected cell. Or, we can set it so that no one can edit these cells. Or even set a custom list of users who can edit the cells. In this case, we leave it as shown in the image below. Finally, we click on the Done<\/strong> button.<\/p>

Example<\/strong> \"Protect<\/p>

Now, what happens when another user tries to edit one of these protected cells? Here's how it prevents them.<\/p>

Example<\/strong> \"Protect<\/p>

There can be other instances when we want to protect an entire sheet or almost all of it. In this case, we can opt for the Sheet button as shown in the image below. We can even exempt cells that we do not want to protect from the protected sheet.<\/p>

Example<\/strong> \"Protect<\/p>","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7071","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=7071"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/7072"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=7071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=7071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=7071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}