Protect Contents, but Not Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On Excel 2000, how do I protect the contents of locked cells, but not the format? This option appears to be available in Excel XP, but not 2000.
 
Hi
AFAIK you can't as this was one of the new Excel 2002 (XP) features
 
You must log in or register to reply here.

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

Similar Threads

How do I delete only the content of cells that are NOT protected? 1
Excel 2000 help please - Cell protection 2
Protect Number Format Only 6
David Biddulph is correct 8
Hiding Formulas and Being Able to Make Changes 2
Sorting while protected - this question may not have been covered. 1
HDMI is a terrible format and I wish it never existed 2
Excel Protection 2

Back
Top