'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Protect and Lock Cells in Excel for Microsoft 365
Question details
Users cannot find the option to protect or lock cells in Excel for Microsoft 365 because they are using the web version.
- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Attempting to secure specific data or formulas from being edited in an online workbook.
- Observed behavior
- The cell locking and worksheet protection options are missing or completely unavailable in the Excel for the Web interface.
Ensure you have the Microsoft Excel desktop application installed, as full cell locking and worksheet protection features are currently unsupported in the web version.
Open in Desktop App and Apply Cell Locking
Since Excel for the web lacks protection features, you must open the workbook in the desktop version to lock cells and protect the sheet.
By default, all cells in Excel are locked, but this locking has no effect until you protect the worksheet. You must switch to the desktop application to adjust these settings and enforce the protection.
Open your file in Excel for the web, click on the 'Editing' button on the top ribbon, and select 'Open in Desktop App'.
In the desktop app, select the cells you want to leave unlocked (editable for other users), right-click them, and choose 'Format Cells'.
Navigate to the 'Protection' tab in the Format Cells dialog box, uncheck the 'Locked' box, and click 'OK'.
Go to the 'Review' tab on the main ribbon and click on 'Protect Sheet'.
Enter a password if desired, specify what actions users are allowed to perform, and click 'OK' to secure the document.
Use WPS Spreadsheet to Lock and Protect Cells
WPS Office provides a fully featured desktop spreadsheet application for free. You can easily lock cells, protect sheets, and encrypt whole workbooks with a familiar interface and seamless format compatibility.
- 1. Open Document: Open your spreadsheet file in WPS Office.
- 2. Unlock Specific Cells: Select the cells you want to remain editable, right-click, select 'Format Cells', and uncheck 'Locked' under the Protection tab.
- 3. Protect Sheet: Navigate to the 'Review' tab on the ribbon and click 'Protect Sheet'.
- 4. Set Password: Enter a secure password, check the permissions you want to allow, and click 'OK' to secure your data.
Frequently Asked Questions
Why is the 'Protect Sheet' button missing in my Excel?
If you are using Excel for the Web (the browser version), the worksheet protection features are not available. You must open the workbook in the Excel desktop application to access these tools.
Does cell protection work if I share the file online?
Yes. If you protect the worksheet using the desktop version of Excel, the protection rules and locked cells will remain active and enforced when other users open the file in Excel for the Web.
How do I unlock cells after protecting a sheet?
You must first unprotect the sheet. Go to the 'Review' tab and click 'Unprotect Sheet' (you will need to enter the password if one was set). Then, you can select the cells, right-click, choose 'Format Cells', and change the 'Locked' status.
