Guida Excel

How to Protect a Worksheet in Excel

Protecting a worksheet prevents unauthorized changes to your data. You can control exactly what users are allowed to modify while keeping sensitive formulas secure.

Fallo con l'IA

Passo passo

1
Select cells to remain editable
Highlight the cells you want users to be able to edit, right-click, select 'Format Cells', go to the 'Protection' tab, and uncheck 'Locked'.
2
Navigate to the Review tab
Click on the 'Review' tab in the top ribbon menu.
3
Enable sheet protection
Click 'Protect Sheet', enter a password if desired, select the allowed actions from the list, and click 'OK'.

Suggerimenti

Always remember your password, as Excel cannot recover it if lost.
You can protect specific ranges instead of the whole sheet by using 'Allow Edit Ranges'.

Domande frequenti

Can I unlock a sheet after protecting it?

Yes, go to the 'Review' tab and click 'Unprotect Sheet'. You will need to enter the password if one was set.

Guide correlate

Come bloccare le celle in Excel