Forum Discussion
marcocol
Jul 30, 2021Copper Contributor
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, ...
- Jul 30, 2021
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.
HansVogelaar
Jul 30, 2021MVP
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.
marcocol
Jul 30, 2021Copper Contributor
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.