Protecting Cells On Spreadsheets

  steviegee 11:58 08 Dec 2009
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 2009

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 2009

Thanks that works, what about for CSV files?

  VoG II 12:51 08 Dec 2009

A CSV file cannot contain formulas???

  Terry Brown 14:33 08 Dec 2009

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

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

Camera tips to take better iPhone photos

Comment transformer un iPhone en borne Wi-Fi ?