After entering your password, click on the ‘Ok’ button. Now, you need to confirm your password that can be easily done by entering the exact same password in Confirm Password Dialog Box. Protect your sheet by entering a password in the Password to Unprotected Sheet column. However, you can deselect either or both of the checkboxes as per your requirement. The first two checkboxes for instance, ‘Locked Cells’ and ‘Unlocked Cells’ are by default selected. These options can be any of the options given in the list such as Format Cells or Insert Columns.
Even if you do not choose any of these options, Excel itself chooses the Protect Worksheet and Contents of Locked Cells check box by default.Ĭhoose any of the checkboxes listed in the Allow All Users of This Worksheet To list box that you wish to be functional when the worksheet protection is operational. In this box, you can choose various options that you want to make available when the worksheet protection is enabled. To enable Protect Sheet, first go to the Review Menu of your spreadsheet, then click on Protect Sheet Command.Īs soon as we click on Protect sheet Command, Excel pops up a dialog box called Protect Sheet dialog box.
#HOW DO I PASSWORD PROTECT CELLS IN EXCEL HOW TO#
Here are simple steps to protect cells in Excel 2010: How to Protect Cells in Excel? Let’s understand this function by the example given below Do you have any idea how to lock cells in Excel? Have you done this before? For this, you will have to unlock all the cells first, then lock only particular cells and ranges before protecting the worksheet.Īlong with this, the function also gives you an option to enable specific users to edit your protected worksheet. In addition to this, if you need to lock only specific cells in a worksheet, you can do so using this amazing function. When you choose to protect a worksheet in Excel, all cells go locked by default, which means it can’t be edited by anyone now. Microsoft Excel gives you an option to lock cells to guard them against any unwanted or unplanned editing.
0 kommentar(er)
