How to put password in an specific fields in Excel?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Exequiel
    Contributor
    • Jul 2012
    • 288

    How to put password in an specific fields in Excel?

    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.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    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.

    Comment

    Working...