Excel doubt

  • Thread starter Thread starter Hari
  • Start date Start date
H

Hari

Hi,

I want to set up a sheet such that others can edit the cell values but
dont want them to overwrite the formatting/data validation in the
target sheet. That is end users have the capability to do typing in
the cell or do a paste special value but cannot paste other cell
directly. Please suggest how I shud go about the same.

Regards,
Hari
 
Hari,

Unlock the cells (Format - Cells - Protection) that users are to be able to
change. Then protect the sheet (Tools - Protection - Protect Sheet). Users
will be able to type into the unlocked cells, but not change the formatting
(unless they paste into them).
 
Back
Top