By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

How to put password in an specific fields in Excel?

Exequiel
100+
P: 287
I have an excel file, and this file have fields with formulas, only the admin allowed to edit the fields for formulas, so those fields with formulas must be lock with password if some personnel wants to edit the field they need to put the password set to edit this specific field for formula. How can I do this in Microsoft Excel?

Any reply are so appreciated. Thank you.
Aug 3 '15 #1

✓ answered by Rabbit

Protect the sheet as your normally would. In the cell formatting, under the Protection tab, it allows you to lock and unlock cells from said protection.

Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,369
Protect the sheet as your normally would. In the cell formatting, under the Protection tab, it allows you to lock and unlock cells from said protection.
Aug 3 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.