Protect the Format Only of a Sheet

J

JohnB

We have a spreadsheet that several people access via a network. The
problem is that whenever one or two of them work in it, some of the
cells are reformatted and rows are inserted at the top of the sheet.
They claim they aren't making these changes. I'm guessing that it has
to do with some default settings on their individual PC.

Is there a way of ‘locking' the formatting on a sheet (or a group of
cells) so that only data could be entered or changed?

Any advice would be appreciated.

Thanks…John
 
E

Earl Kiosterud

John,

Worksheet protection prevents format changes, even for cells that are
unlocked. You unlock cells whose contents are to be changeable (Format -
Cells - Protection), then protect the sheet (Tools - Protection - Protect
sheet).
 
Top