How do I protect spreadsheet formatting & formulas?

[rippedit123]

Hi guys,

Is there a way to protect an excel spreadsheet, so that users can input data in specific columns, but are restricted from changing the formatting of the cells such as size, borders.

Also how do I protect the formulas from being deleted?

Thanks

 

[Eric W]

Right click on the cells (or ranges) you want the users to have access to. Select Format Cells... > Protection > and uncheck the Locked box. Now go to the Review tab, and click Protect Sheet. Now they can only change the cells you allowed.

 

[rippedit123]

Thanks very much Eric. I'll give it a try and let you know how I get on. Much appreciated.