Forum Discussion
Protected sheet - how to edit text in unlocked cells
I have an excel spreadsheet with a protected sheet. There are certain unlocked cells that allow for data input. My issue, is around updating data in the unlocked cells. Once data has been input i...
Thanks for your assistance. I have found the solution. I had the cell "hidden", so when the sheet was protected, the text would disappear instead of allowing me to edit it.
I have now unchecked the "hidden" setting under "Format Cells" and I can now edit the text on a protected sheet.