How lock cell format, but not lock cell contents?

G

Gavin

I'm no boffin on this subject, and I may have this all
wrong, but to me the answer is simple:

Select the cells that will need thier contents changed, go
to Format, Cells and go to the Protection tab (far right).
REMOVE the tick from Locked. Now switch on sheet
protection.

Your cells will be protected against format changes, but
will still allow content changes.

Gavin
 

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