protect sheet with password in Excel

Q72. In Excel, how can I prevent edits on my worksheet by protecting it with a "Password"?

For example, I have a data table in my worksheet sourced from elsewhere. Data in the Table cannot be altered at any cost as it affects the rest of my Workbook. In Excel, how can I prevent users from editing this sheet, even inadvertently?

excel protect sheet with password

To do it in Excel, here is the answer:

a) Click on "Protect Sheet" under "Review".

excel excel protect sheet with password

b) In the "Protect Sheet" dialog box that pops up, enter a "Password". Click OK.

excel excel excel protect sheet with password

c) In the "Confirm Password" dialog box that pops up, re-enter "Password". Click OK.

excel excel excel excel protect sheet with password

d) The Worksheet is now password protected. When the user tries to edit a cell, following message pops up.

excel excel excel excel excel protect sheet with password

 

You can find similar Excel Questions and Answer hereunder

1) Vba code to password protect workbook in Excel

2) Remove the apostrophe cell text values in Excel

3) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

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

5) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

6) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

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

8) How can I execute an event at a predetermined time from my Macro?

9) Applying a countif formula only to visible cells in a filtered list in Excel

10) Vba clear the contents of an entire sheet in Excel

11) Vba code to password protect workbook in Excel

12) How can I add a WorkSheet and name it as required using VBA?

13) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?

14) How can I prevent other users from adding or deleting Sheets in file?

15) I conducted a test and the test scores are available - how can I get Percentile rank of students?