J
JanetW
I am creating a spreadsheet which will be protected with a table of
cells unlocked for the user to fill in. There are formulas which
reference the unlocked cells. Is there anyway to prevent these formulas
from changing if the user drags (or cut-and-pastes) the unlocked cell
(ie, if they type data in the wrong cell and then drag that data to the
correct cell, any formula reference these two cells gets modified)?
Thanks!
cells unlocked for the user to fill in. There are formulas which
reference the unlocked cells. Is there anyway to prevent these formulas
from changing if the user drags (or cut-and-pastes) the unlocked cell
(ie, if they type data in the wrong cell and then drag that data to the
correct cell, any formula reference these two cells gets modified)?
Thanks!