Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Excel problem 2 - protecting cells  (Read 3086 times)

0 Members and 1 Guest are viewing this topic.

Gerryl

  • Guest
Excel problem 2 - protecting cells
« on: April 18, 2005, 07:27:27 AM »
Hi,

I know how to protect a whole worksheet but can't find out how to protect indvidual cells in Execl 2002. Can anyone help please. I don't want the little blighters to change the formula in my Times Tables as described in Execl Problem 1 - adding True's
Thanks

gussery

  • Guest
Re: Excel problem 2 - protecting cells
« Reply #1 on: April 18, 2005, 07:44:56 AM »
Select the cells you want to "protect", right click, choose format cells, protection, check locked.  Cells are locked by default, if I remember correctly, so you may want to select the cells that you want unlocked and unlock them.

The select Tools, Protection, Protect Sheet from the main menu.  Select the options you want, probably locked cells but not unlocked cells.