Lock Down Excel Spreadsheet

[Searching]

Is there a way to lock down an excel spreadsheet so that users cannot make changes to the formulas? Users will be entered data in the cells on tab1 and the formulas are listed on tab2

 

[mumps]

Make sure all the cells in Tab2 are locked and then protect the sheet.

 

[Searching]

How do you lock the cells in tab2 and protect? There will be multiple user accesses tab2

 

[mumps]

All the cells in a worksheet are locked by default so if you haven't unlocked any cells, then they are already locked. If you want to prevent anyone form changing the formulas but allow them to enter data in those cells without formulas, then you have to unlock the cells without formulas. You can do this one cell at a time or by selecting a range of cells, right clicking on any of the selected cells and click 'Format Cells', click the 'Protection' tab and uncheck the 'Locked' box. Then you protect the worksheet with or without a password by clicking the 'Cells' group in the 'Home' tab at the top, then click 'Protect Sheet'.