[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”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.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Whether you are using Excel or Google Sheets, spreadsheets have become a key tool for collaboration. That is until accidental (or even purposeful) edits occur, which negatively impact your entire dataset.<\/p>\n
Imagine arriving at your Excel spreadsheet to resume your work from the day before, except nothing looks like how you left it. This is the point where you probably wish you could turn back time or at least have protected the work you had done so far. Knowing how to lock cells, a sheet or a formula in Excel is extremely useful in these cases. Moreover, knowing how to unlock cells in Excel<\/a> is just as important since you may wish to make some parts of the document editable again.<\/p>\n By the end of this article, you will know how to lock specific cells, shared files\/sheets, and formulas in Excel. So, without further ado, let\u2019s explore these methods to ensure that you maintain control over your hard work.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-lock-cells-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In simple terms, when you lock a cell in Excel, other users are automatically restricted from making changes to that information. As mentioned before, in cases where a spreadsheet will be modified or edited by several people, it will make everyone\u2019s life easier if you either prevent them from changes or pre-approve specific users.<\/p>\n 1.<\/strong> First of all, you need to select the cells that you want to lock.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/how-to-lock-cells-in-excel-select-range.webp” alt=”How to lock cells in Excel \u2014 a contact list range selected in the worksheet” title_text=”A contact list range selected in the worksheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to the \u201cHome\u201d tab of your Excel sheet and select \u201cFormat\u201d to the far right.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-cells-in-excel-home-tab-format.webp” alt=”Lock cells in Excel \u2014 Home tab ribbon with the contact list still selected” title_text=”Home tab ribbon with the contact list still selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> From the drop-down menu, choose \u201cLock Cell\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-cells-in-excel-format-menu-lock-cell.webp” alt=”Lock cells in Excel \u2014 Format menu with Lock Cell highlighted under Protection” title_text=”Format menu with Lock Cell highlighted under Protection” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n IMPORTANT:<\/strong> Although your selected range is now locked, it is still editable. This is because the sheet itself has not been protected. If you wish to prevent others from editing the content in these cells, you need to proceed to the following section.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-lock-a-sheet-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In order to lock a sheet in Excel, you simply have to use the protect feature in the spreadsheet app. Please note that in order to lock a sheet in Excel, the previous steps have to be completed.<\/p>\n 1.<\/strong> Go to the \u201cReview\u201d tab and select \u201cProtect Sheet\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-sheet-in-excel-review-protect-sheet.webp” alt=”Lock a sheet in Excel \u2014 Review tab showing the Protect Sheet button” title_text=”Review tab showing the Protect Sheet button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> A small window should pop up which will allow you to protect the sheet and its corresponding contents by optionally setting a password or directly ticking the permissions you would like to grant users on this sheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-sheet-in-excel-protect-sheet-dialog.webp” alt=”Lock a sheet in Excel \u2014 Protect Sheet dialog with optional password and user permissions” title_text=”Protect Sheet dialog with optional password and user permissions” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n IMPORTANT:<\/strong> By not protecting with a password, any of the users having access to this sheet are able to click on the “Unprotect Sheet” option and make the changes they want. You can learn more about password protection in our two blog articles on how to password protect an Excel file<\/a> and how to password-protect a Google Sheet<\/a>.<\/p>\n 3.<\/strong> Lastly, to make sure you have successfully locked cells, you can check to see if the \u201cUnprotect Sheet\u201d option appears in the Review toolbar.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-sheet-in-excel-unprotect-sheet-button.webp” alt=”Lock a sheet in Excel \u2014 Unprotect Sheet button in the Review tab after protecting” title_text=”Unprotect Sheet button in the Review tab after protecting” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Another way to see if this has worked is to type directly in the locked cell. If you were successful, you will get the following alert message.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/locked-cell-in-excel-protected-sheet-alert.webp” alt=”Locked cell in Excel \u2014 alert saying the cell is on a protected sheet” title_text=”Alert saying the cell is on a protected sheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Remember that you do not need to password protect the whole sheet to lock specific cells or content ranges in your spreadsheet. As shown in the list of lockable items above, you can also restrict users from formatting, sorting, or filtering content in the cell(s).<\/p>\n In the next section, you will learn how to narrow your locking range to a single cell instead of a column, row, or specified range.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-lock-specific-cells-in-excel-and” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sometimes, you will need your team to continue working on or updating the content of a spreadsheet and will have to limit the locked content to a minimum. This is where locking specific cells comes in handy. But, before we continue, make sure you click \u201cUnprotect Sheet\u201d.<\/p>\n 1.<\/strong> Before you begin, make sure that you click “Unprotect Sheet” in the Review toolbar. Every cell in Excel is locked by default, so unlock the whole sheet first: press Ctrl+A (Cmd+A on Mac) to select all cells, open Format Cells, and untick “Locked” on the Protection tab.<\/p>\n 2.<\/strong> Select the cell(s) you wish to lock and press “Ctrl+1” on Windows or “Cmd+1” on Mac to launch the “Format Cells” window. Note how in this case, I have only selected the first seven email addresses.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-specific-cells-in-excel-format-cells.webp” alt=”Lock specific cells in Excel \u2014 Format Cells window with seven email addresses selected” title_text=”Format Cells window with seven email addresses selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Go to the “Protection” tab and make sure the “Locked” option is ticked before clicking “OK”.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-specific-cells-in-excel-protection-locked.webp” alt=”Lock specific cells in Excel \u2014 Protection tab with the Locked box ticked” title_text=”Protection tab with the Locked box ticked” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Go to the “Review” tab and click “Protect Sheet”. Only the cells you locked are protected now, and people can still edit the rest of the sheet.<\/p>\n This shortcut to locking cells in bulk will make it easier to protect the data you want to remain intact. The next section will explain how to lock a cell in Excel that contains a formula.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-lock-formulas-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In many circumstances, you may have formulas in your Excel to handle important calculations of data. If these cells containing the formulas are changed (accidentally or not), not only will the cell be affected, but the row, column, or even the entire sheet.<\/p>\n 1.<\/strong> A formula cell that is unprotected will showcase a small green triangle on the top-left corner as well as a warning sign.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-formulas-in-excel-unprotected-formula-warning.webp” alt=”Lock formulas in Excel \u2014 warning icon next to an interest rate formula cell” title_text=”Warning icon next to an interest rate formula cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Click on the warning sign icon and select the option \u201cLock Cell\u201d from the drop-down menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-formulas-in-excel-lock-cell-option.webp” alt=”Lock formulas in Excel \u2014 Unprotected Formula menu with the Lock Cell option” title_text=”Unprotected Formula menu with the Lock Cell option” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Similar to the steps on How to lock a sheet in Excel<\/a>, go to the \u201cReview\u201d tab and click on \u201cProtect Sheet\u201d to protect the formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/lock-formulas-in-excel-review-protect-sheet.webp” alt=”Lock formulas in Excel \u2014 Review tab Protect Sheet with the formula cell selected” title_text=”Review tab Protect Sheet with the formula cell selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You may also protect the formula by locking the specific cell formulas in your sheet, using the same steps on how to lock specific cells in Excel<\/a>. To select every formula on the sheet at once, open Find & Select on the Home tab, click Go To Special, choose Formulas, and click OK.<\/p>\n Sometimes “locking a cell in a formula” means something else: keeping a cell reference fixed when you copy the formula to other cells. For that you need an absolute cell reference<\/a>. Add a $ sign before the column letter and the row number (for example, $A$1), or click the reference in the formula bar and press F4 on Windows or Cmd+T on Mac.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n These locking methods in Excel are vital to ensure your spreadsheet data is safe from unwanted changes. Learning how to lock cells, sheets, or formulas within Excel will help you avoid any risk of having to edit mistakes manually down the line, which can end up becoming extremely time-consuming and unproductive.<\/p>\n By the end of this article, you should know how to lock cells, specific cells, cell formulas, and protect sheets, including passwords, in Excel.<\/p>\n If your team also works in Google Sheets, see how to protect cells or pages in Google Sheets<\/a>. When several people need the same numbers, you can keep the source workbook locked and let Sheetgo’s AI automations<\/a> copy the data into the files each person edits.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Apprenez \u00e0 verrouiller des cellules dans Excel pour \u00e9viter les modifications accidentelles, ainsi qu'\u00e0 prot\u00e9ger une feuille et verrouiller des formules, avec les \u00e9tapes pour Windows et Mac.<\/p>","protected":false},"author":2,"featured_media":266343,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-266330","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266330","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=266330"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266330\/revisions"}],"predecessor-version":[{"id":266344,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266330\/revisions\/266344"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/266343"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=266330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=266330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=266330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to lock cells in Excel?<\/h2>\n
How to lock a sheet in Excel?<\/h2>\n
How to lock specific cells in Excel (and keep the rest editable)?<\/h2>\n
How to lock formulas in Excel?<\/h2>\n
Conclusion<\/h2>\n