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.

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5