Protect Cells in Excel

  Micklemass 15:44 12 Apr 2004
Locked

Can I protect individual cells in Excel or only a complete worksheet. I have a Chess League results and tables which are updated by a friend then e mailed to me for inclusion in our website. Wanted to prevent cells with formula being acidently erased.

  VoG II 15:48 12 Apr 2004

What you have to do is:

1. Select the cells that you do NOT want to select, Format/Cells, Protection tab and untick Locked and Hidden.

2. Tools/Protection, Protect sheet.

  VoG II 15:49 12 Apr 2004

"that you do NOT want to PROTECT" I mean.

  Micklemass 15:59 12 Apr 2004

All done. Was confused as I think in older excel's or Lotus 123 you protected cells individually.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?