Forum Discussion
Solved
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, ...
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.
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.
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.