protect only limited part of the sheet with password in Excel

Q73. I am planning to protect my sheet using a password. However, for select cells I would like users to be able to edit the cells. In Excel, how can I achieve that?

For example, in my financial calculator, I have a Table where users have to provide input in some of the fields - cells shaded in light blue in the screenshot below.

How can I set up the Worksheet such that these user input fields are editable even after I password protect my sheet?

excel protect only limited part of the sheet with password

To do it in Excel, here is the answer:

a) Select the Input cells that are supposed to be editable. Right click and select "Format Cells".

excel excel protect only limited part of the sheet with password

b) In the "Format Cells" dialog box that pops up, "uncheck" the "Locked" field in "Protection" tab. Click OK. The cells of interest are editable even after password protecting the Worksheet.

By default, all cells have the "Locked" field checked. When a cell "Locked" field is "unchecked", that cell is editable even if the Worksheet is password protected.

excel excel excel protect only limited part of the sheet with password


You can find similar Excel Questions and Answer hereunder

1) How to center excel sheet horizontally and verticaly on page in Excel

2) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?

3) I have entered lot of comments in my WorkSheet - how do I have them show up when printed?

4) How can I quickly remove all blank cells in a data range?

5) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?

6) How can I show summary reports with Totals only hiding all the rows containing the details?

7) How can I clear all formats (formats alone not data) from a range of cells?

8) Can I apply formatting to a number concatenated with a Text?

9) How can I protect / unprotect WorkSheet using VBA?

10) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?

11) Can I determine the number of times a character appears in a cell using formula?

12) How can I identify the cells that are dependent on a particular cell?

13) How to add a link in a sheet to another sheet

14) Vba code to password protect workbook in Excel

15) How can I prevent edits on my worksheet by protecting it with a Password ?