I`m trying to lock cells with formulas (so they only update when changes are made to other cells they refer to) and not if data is manually entered into them.
However excel keeps telling me to "protect" the worksheet first, otherwise cells won`t lock, but when I do this I can`t make changes to any of the cells in other columns.
columns D,F,G, and H in this sample need to be locked from manually typing in changes.
How would I do this?
see attached.
lockingcells.png
demo-targets.xlsx
Bookmarks