Go to ToolsProtection and Allow users to edit range, this will allow you to
set passwords for various users on several ranges.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"SS" wrote:

I would like to set a password to certain group of people in order for them
to modify the related column. Means that Group A only allow to modify the
data in Column A-C, Group B only allow to modify the data in Column D-F,
otherwise only able to view, is there anyone can advise me?