Forum Discussion

Copper Contributor

Dec 05, 2024

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...

excel

KanwalNo1

Iron Contributor

Dec 05, 2024

Instead of double clicking, have you tried pressing F2 ?

elwar1
Copper Contributor
Dec 05, 2024
I have just tried pressing F2 instead of double clicking as you have suggested, but the same thing occurs. The text disappears instead of placing a cursor inside the cell text to allow me to edit it.