Jan 04 2021 03:37 AM
Hi! I would like to ask for help with my excel file. I would lock to lock formatting, deleting, or typing on all cells except the cells filled with the color green. How can I do this? Thank you for helping! Can I also get the step by step procedure?
Jan 04 2021 04:28 AM
SolutionThis is a two-step process. By default, all cells are locked but this only becomes effective when you protect the worksheet.
Step 1: unlock cells.
Step 2: protect worksheet.
Jan 04 2021 04:30 AM
You might be best served by this YouTube video https://www.youtube.com/watch?v=PiRVgAZnGGA
It explains the process fully, and would enable you to implement it on your own.
Jan 04 2021 04:28 AM
SolutionThis is a two-step process. By default, all cells are locked but this only becomes effective when you protect the worksheet.
Step 1: unlock cells.
Step 2: protect worksheet.