How do make cells F9:R1999 READ-ONLY ?

  • Thread starter Thread starter lothario
  • Start date Start date
L

lothario

Hi,

I have one spreadsheet in one workbook.

Is there a way to make cells F9:R1999 READ-ONLY ?

So that the user is able view the contents of F9:R1999 but not change
them.

And the rest of the cells can be changed by anyone.

Thanks,
Luther
 
Hi Luther,
All cells are protected by default.
You need to turn off protection in the cells/ranges you DO want users to
edit in.

Select the range, then format>cells protection tab. Uncheck protect.

All you have to do is turn on worksheet protection.
Tools>protection>protect worksheet. Add a password if you wish.
 
Back
Top