By default, Excel locks all the cells in a protected worksheet, and then you can specify which cells you want to unlock for editing if any. You can make the file open as read-only by default so that people have to opt into editing it. Then, select the cells with formulas. Whatever the reason, you can easily lock only certain cells in Microsoft Excel. They will receive an error message if they try to modify the protected cells or ranges. By default, Excel selects the Protect Worksheet and Contents of Locked Cells check box.
But, after you close it, the next time you open it, Excel will prompt you to enter the password. Prevent Editing in Excel Cells With the Lock function in Excel, you can prevent users from editing specific cells with formatting and formula while still allowing them to modify the rest of your sheet. If you are working with light analysis and simpler modeling, Google Docs Spreadsheet is a good choice. If your Excel sheet is locked with protected password, follow the 3 ways below to for editing. It could lead to data-chaos. To set it up, open your Excel file and head to the File menu.
This method of selecting the cells you want to stay unlocked and then locking the sheet works better. Google Docs recently solved this problem by introducing restrictions on editing cells and also another layer of protection where you can also protect entire sheets. If you ever want to remove the password protection from the file, open it up which of course requires you to provide the current password , and then follow the same steps you used for assigning the password. For example, in a budget worksheet, you may want to allow changes only in the cells where you enter the budgeted amounts. They can then enter the password. Leave a Reply Your email address will not be published.
To set it up, open your Excel file and head to the File menu. Following the instructions in , I have protected the worksheet and this works with one exception: If I double-click a text-field then its contents are erased. Unlocking cells Usually, your intention in protecting cells is not to prevent all changes but to prevent changes in certain areas of the worksheet. The other way around, if you want to lock specific cells and allow user to edit all other cells then read this: 1. Just click on the Remove Password button. Protect a Worksheet from Editing You can also protect individual worksheets from editing. You can add multiple protected ranges.
Select the permissions you would like users to have for the worksheet after it is locked. Protecting your worksheet means that no one can edit, reformat, or delete the content. I need the formatting protected, but allow users to edit text and select from drop-down boxes. To make a change, unprotect the sheet. Sembera now writes full time about business and technology. Excel opens the Protect Sheet dialog box in which you select the options you want to be available when the worksheet protection is enabled. Each cell in the worksheet can be locked or unlocked.
Alternatively, you can use the keyboard shortcut Ctrl + 1. You will find the Excel sheet password is removed soon. The Excel spreadsheet is locked with password If the Excel sheet or cell is locked with protection password, you won't be able to make change to it unless you unprotect it first. Technically this method involves protecting a worksheet and then allowing certain cells to be exempt from that protection. Excel allows you to make these changes either by using the ribbon commands or by using mouse shortcuts. When you protect a worksheet, Excel locks all of the cells from editing.
This is very important and useful if your worksheets have a complex set of formula that you use across a span of time where different information is encoded in set categories. Just the way we wanted it. Protect Specific Cells From Editing Sometimes, you may only want to protect specific cells from editing in Microsoft Excel. How to enable editing in Excel? To use the Lock function, you have to first open an Excel file. For example, you want to allow user to edit range A2:A9 which is Name column and protect all other cells of this worksheet 2.
Provide password and click on check box for the things you want to allow users to do. Excel today has managed to expand on its basic worksheet features to become more intuitive and to match our needs and technology. And then click on Run button or press F5 to run. Unprotect Excel sheet with password If you still remember the password for the protected sheet, unprotecting Excel sheet is a piece of cake. For example, you might want to allow people to format, but not delete, rows and columns.
Notice that if you try to edit a cell, Excel displays an error message. His professional career includes stints as a computer tech, information editor and income tax preparer. Return to the main Excel window with your spreadsheet. Tell us if this walkthrough was helpful. I'm not sure why double-clicking erases the contents of your text fields here is what I did and it worked as you'd want it to:.