Protecting Cells On Spreadsheets

  steviegee 11:58 08 Dec 09
Locked

Is it possible to protect cells on spreadsheets especially ones containing formulas. I don't want the entire sheet protected as I want people to edit certain things on the file but not change any formulas. thanks.

  VoG II 12:04 08 Dec 09

Select the whole sheet by clicking the grey square to the left of A and above 1.

Format > Cells > Protection tab, untick Locked and click OK.

Press F5, click Special, tick Formulas and click OK.

Format > Cells > Protection tab, tick Locked and click OK.

Tools > Protection > Protect sheet.

  steviegee 12:44 08 Dec 09

Thanks that works, what about for CSV files?

  VoG II 12:51 08 Dec 09

A CSV file cannot contain formulas???

  Terry Brown 14:33 08 Dec 09

Thanks VOG, marked it for my reference as well.
Terry

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…