Link to home
Start Free TrialLog in
Avatar of Jody Reid
Jody ReidFlag for United States of America

asked on

New excel spreed sheet

I got some great help yesterday with my new spreadsheet but I have just 1 more question. I need to lock down my sheet apart from the cells that I need people to enter data which is about 10 cells in different parts of the sheet. Is there a way to do this. Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Brad Groux
Brad Groux
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steven Carnahan
Brad is correct. In my experience I have always had to unlock the cells first then lock the spreadsheet.

Remember that if you don't want the users to be able to just unlock the spreadsheet then you need to password protect.