Unlock specific cells

Gianni

Hi SS community,

I am trying to unlock a specific cell in a sheet. The column needs to be locked because it is a "Start Date" column, but the one row needs to be manually inputted. Can I lock the entire column, but unlock the row or something? Please help me figure out a solution to this. Thanks!

Jeff Reisman

@Gianni

You can't unlock a single cell in a locked column. To do what you want, I suggest using an unlocked helper column to collect that manual input, and in the locked column's cell where you need that input, use a formula to reference that specific helper column cell (such as =HelperColumn1 or =HelperColumn$1).