Forum Discussion
Excel Spreadsheet locking/protecting help
Hi there. I'm pretty old school and I'm not very technical with Excel and am somewhat unfamiliar with it. I've also never used this facility. I've got Microsoft 365. If I've completed a Spreadsheet, and I need to email it to someone, but I don't want that person/organization to be able to make any changes to any formulas, or any cells or columns, nor be able to copy any cells / columns. They can be allowed to add/subtract/multiply/divide any of the cells and/or columns, if they need to. Is there a way that I can lock or protect this spreadsheet to do this, perhaps?
Your help will be much appreciated. Thank You. Marco
You Sir, are an absolute genius! Thank you so very much for your help. It works! You're a good man. Have a good weekend.
4 Replies
You write "I don't want that person/organization to be able to make any changes to any formulas, or any cells or columns, nor be able to copy any cells / columns.".
But that would also make it impossible to "add/subtract/multiply/divide any of the cells and/or columns"...
- Oh I see. Okay, so that could be fine too. They'll just have to manually create a separate sheet and retype the numbers, in the event that the may want to calculate, I suppose. I'm fine with that, yes. Is the rest of my query possible then still? Thank you for your kind response.
Activate the Review tab of the ribbon.
In the Protect group, click Protect Sheet.
Clear the check boxes 'Select locked cells' and 'Select unlocked cells'.
If you wish, enter a password that will be needed later on to unprotect the worksheet.
Don't forget this password!
Click OK.
If you provided a password, you will have to enter it again as confirmation.
Save the workbook.
