Question by : How to password protect worksheets in Excel?
I need to know if anyone knows how to password protect a worksheet that is in a workbook for excel. I tried looking in up and couldn’t find it. I work in an office, and do human resources and i need to protect certain worksheets that are in shared folders. Thank you!!!
Answer by hail2pitt02
click save as like you normally would and name your file. Before you click save, select tools from the top right, and then general options from the drop down. Once you do that you enter in the password to open the file, and another to modify the file if you want.
That’s all there is to it.
Give your answer to this question below!