×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

"Locking" cells

"Locking" cells

"Locking" cells

(OP)
Using Excel, is there any method of "locking" individual cells, but not the entire workbook?

I want our guys to be able to change data in some cells, but not allow them to "accidentally" erase the formulas in others.

Thanks for any help.

RE: "Locking" cells

Sure. All you have to do is protect the worksheet. First, you will have to change a property for the cells you want to let the user modify. For those cells, do a Format > Cells and go to the Protection tab. Uncheck the Locked option. Then, when you protect the worksheet (Tools > Protection > Protect Worksheet), the cells you changed will not be locked for user modification. All of your forumulas will be intact.

Hope that helps...

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: "Locking" cells

From the menu select Format, Cells, click the Protection tab, ticking the locked box will specify the cell(s) selected as locked. I suggest you lock all the cells then select the individual cells you want to unlock.

You can use styles and specify locked/unlocked cells for each style.

Remember, the cells won't actually be locked until you protect the sheet/workbook with Tools, Protection, Protect Sheet/Protect Workbook.

RE: "Locking" cells

(OP)
Thanks a bunch, guys.  I appreciate it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources