Forum Discussion

marcocol's avatar
marcocol
Copper Contributor
Jul 30, 2021
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, ...
excel
  • marcocol's avatar
    marcocol
    Jul 30, 2021

    HansVogelaar 

    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's avatar
HansVogelaar
MVP
Jul 30, 2021

marcocol 

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"...

marcocol's avatar
marcocol
Copper Contributor
Jul 30, 2021
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.
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 30, 2021

    marcocol 

    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's avatar
      marcocol
      Copper Contributor
      Jul 30, 2021

      HansVogelaar 

      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.

Resources