Excel Can you lock the value of a cell but not the format?


Joined
Apr 20, 2017
Messages
1
Reaction score
0
I am creating a status document. I want to lock the number value in a cell but allow the users to change the color format or fill of the cell. Is this possible?
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Yep you can do that. On the ribbon select the Review tab, and then click on Protect Sheet. It will then take you to an option box where you can add a password and specify what you want users to be able to do.

Welcome to the forum! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top