01-24-2019 11:39 AM
01-24-2019 07:09 PM
first, you need to format all cells that should be selectable. In the formatting dialog, go to the Protection tab and untick the option for Locked.
Next, go Review > Protect sheet. In the dialog that appears, there are options for which selections to allow. One is to allow selecting only unlocked cells.
Does that help?
by cuong on April 22, 2020