How can you protect your worksheet from anyone editing the data?
There are two ways in order to prevent anyone from editing the data :
* You can password protect the worksheet so that only those who have the password can open the sheet. To do this go to Menu bar >Review > Protect Sheet > Password.
* Lock the range. First, select the range that you want to lock, then right-click anywhere. Then go to the ‘Format Cells’ option from the drop-down menu and go to the ‘Protection’ tab. There tick the ‘Locked’ option if it isn’t ticked, then press OK.
