excel help

  harps1h 14:52 11 Mar 2007

how do you lock individual cells that contain formulae

  VoG II 14:57 11 Mar 2007

If you mean all cells that contain formulas:

Select the whole sheet (click the grey square between A column header and 1 row header). Format > Cells > Protection, untick Locked.

Edit > GoTo > Special > Formulas, Format > Cells > Protection, tick Locked.

Tools > Protection > Protect Sheet.

  harps1h 15:33 11 Mar 2007

once the cells are protected, as a experiment can if i delete the formula and close the program does this stop the formulae from being destroyed?
i am a novice with excel

  VoG II 15:35 11 Mar 2007

If the cells are protected you shouldn't be able to delete or add anything in those cells. Try it - you should get a pop-up warning.

  harps1h 15:39 11 Mar 2007

whenever i protect the sheet i can delete formulas but i cannot replace them without unprotecting the sheets first. have i done something wrong? i need the formula cells not to be over written in this manner

  VoG II 15:43 11 Mar 2007

When you protect the sheet make sure that 'Protect worksheet and content of locked cells' is ticked.

If that still doesn't work, make sure that you have actually locked the cells - unprotect the sheet, click in one of the formula cells, Format > Cells > Protection and check that Locked is ticked.

  harps1h 15:46 11 Mar 2007

thank i'll give it a go now.

i'll be in touch


  harps1h 20:36 11 Mar 2007

thank you vog for your assistance. it is working perfectly.


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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse's new logo: the trainer brand looks to its heritage for a fresh identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans ├ęchec ?