Protect Cells in Excel

  Micklemass 15:44 12 Apr 04
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 04

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 04

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

  Micklemass 15:59 12 Apr 04

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…