{"id":1957,"date":"2022-08-07T10:29:37","date_gmt":"2022-08-07T07:29:37","guid":{"rendered":"https:\/\/www.addictivetips.com\/?p=202733https:\/\/www.addictivetips.com\/microsoft-office\/lock-excel-cells-prevent-editing\/"},"modified":"2022-08-07T10:29:37","modified_gmt":"2022-08-07T07:29:37","slug":"how-to-lock-excel-cells-with-formulas-to-prevent-editing","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1957-how-to-lock-excel-cells-with-formulas-to-prevent-editing\/","title":{"rendered":"How To Lock Excel Cells With Formulas To Prevent Editing"},"content":{"rendered":"

MS Excel is an exceptionally powerful tool. If you can code, Excel is likely of little consequence to you. For those who can\u2019t code, this app is heaven sent. It offers a wide range of features and can be used in a myriad of industries where workers are more likely to be familiar with it than with another brand solution. If you know your way around Excel, you can probably create custom sheets that streamline repetitive tasks. Obviously, you\u2019d make use of the extensive formulas and formatting tools in Excel. At the end of the day, there\u2019s just one thing you need to worry about; other people modifying your sheet. The good news is, you can lock Excel formulas to prevent editing while still allowing users to edit the sheet.<\/p>\n

\"\"<\/span><\/p>\n

Lock Excel Cells<\/h3>\n

Open an Excel file and add the formulas and formatting you need to your sheet. Save the \u00a0changes you\u2019ve made. Next, select the cells that have formulas added to them. We\u2019re assuming that you want other people to be able to edit the variable values but not the formulas that are going to be applied to them.<\/p>\n

In the image above, the cells B2 and B3 are variable cells. The cell B4 contains the formula that will sum the cells B2 and B3. You want users to be able to input any value in the cells B2 and B3 but you don\u2019t want them to accidentally (or intentionally) edit the sum formula.<\/p>\n

Right-click inside the cell that contains the formula and select \u2018Format cells\u2019 from the context menu.<\/p>\n

\"\"<\/span><\/p>\n

A new window will open. Go to the \u2018Protection\u2019 tab on this window and enable both the Lock and Hidden option.<\/p>\n

\"\"<\/span><\/p>\n

Once you\u2019re done, close this window and return to the main Excel window. Go to the Review tab and click the \u2018Protect sheet\u2019 button. Make sure the Protect worksheet and contents of locked cells\u2019 option is checked. You can enter a password to make sure no one can unlock the cells but it isn\u2019t necessary. If you think not being able to view the formula is enough to deter someone, you can skip the password. If not, go ahead and add one.<\/p>\n

\"\"<\/span><\/p>\n

Unlock Excel Cells<\/h3>\n

To unlock Excel cells, go to the Review tab and click Unprotect sheet. If the author of the sheet has added a password to protect it, you will need to enter the password in order to unlock the cells. If there\u2019s no password, you will be able to edit the locked cells after clicking the unprotect sheet button.<\/p>\n

\"\"<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

MS Excel is an exceptionally powerful tool. If you can code, Excel is likely of little consequence to you. For those who can\u2019t code, this app is heaven sent. It offers a wide range of features and can be used in a myriad of industries where workers are more likely to be familiar with it …<\/p>\n","protected":false},"author":1,"featured_media":1958,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[36],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1957"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1957"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1957\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1958"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}