SOLVED

Excel file how to block some cells

Copper Contributor

Ho un MacBook Pro (2021). Sto usando Microsoft Office365.

Ho bisogno di bloccare (bloccare) alcune celle (contenenti funzioni) per evitare che qualcuno modifichi le formule contenute.

Non sembra possibile, nonostante abbia operato format- cells- protection- locked.

Qualcuno può aiutarmi? grazie

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Severo-939 

This is a two-step process. By default, all cells are locked, but this only becomes effective when you protect the sheet.

 

Step 1: Unlock cells.

  • Select the cells that the users should be able to edit.
  • Press Ctrl+1 to activate the Format Cells dialog.
  • Activate the Protection tab.
  • Clear the Locked check box.
  • Click OK.

Step 2: Protect sheet.

  • Activate the Review tab of the ribbon.
  • Click Protect Sheet.
  • If you want to protect the sheet with a password, enter it. Do not forget it!
  • Click OK.
  • If you specified a password, you'll have to enter it again as confirmation.

@Hans Vogelaar

Tante grazie HANS!!! 

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Severo-939 

This is a two-step process. By default, all cells are locked, but this only becomes effective when you protect the sheet.

 

Step 1: Unlock cells.

  • Select the cells that the users should be able to edit.
  • Press Ctrl+1 to activate the Format Cells dialog.
  • Activate the Protection tab.
  • Clear the Locked check box.
  • Click OK.

Step 2: Protect sheet.

  • Activate the Review tab of the ribbon.
  • Click Protect Sheet.
  • If you want to protect the sheet with a password, enter it. Do not forget it!
  • Click OK.
  • If you specified a password, you'll have to enter it again as confirmation.

View solution in original post