Why Excel Protected Sheet Padlock Icons Disappeared
Question details
The user wants to know why Microsoft Excel for Windows no longer shows padlock icons on protected worksheet tabs and whether the indicators can be restored.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- The user protects worksheets in Excel and expects a padlock indicator on the protected sheet tabs.
- Observed behavior
- Excel no longer shows padlock icons on protected worksheet tabs because Microsoft intentionally removed the indicator.
Check your Excel version and update channel, because the removal of the padlock indicator is part of current Excel for Windows updates and is not caused by a corrupted workbook.
Verify worksheet protection without the padlock icon
Use this method to confirm whether a worksheet is still protected when the padlock icon is missing.
Excel removed the padlock indicator intentionally, but the workbook protection state is still available in the Review tab.
Open the affected workbook in Microsoft Excel for Windows.
Click the worksheet tab you want to check.
Click the Review tab on the ribbon and look at the Protect Sheet button. If it shows Unprotect Sheet, the worksheet is protected. If it shows Protect Sheet, the worksheet is not protected.

Submit feedback to Microsoft to request the padlock icon back
Use this option if you want the visual protection indicator restored in a future Excel update.
Use WPS Spreadsheet for Clear Sheet Protection Indicators
If the missing Excel padlock icon disrupts your workflow, WPS Office is a free, lightweight alternative that opens and saves .xlsx files, offers a familiar ribbon interface, and gives you direct sheet protection controls with visible status in WPS Spreadsheet.
- 1. Download WPS Office: Click Download WPS Office Free and install WPS Office on Windows.
- 2. Open your Excel workbook: Launch WPS Spreadsheet and open the .xlsx workbook you need.
- 3. Manage protection clearly: Select a worksheet and use Review > Protect Sheet to apply or check protection in WPS Spreadsheet.

Frequently Asked Questions
Is a missing padlock icon a sign that my worksheet is no longer protected?
No. The padlock icon was removed from the worksheet tab, but the worksheet can still be protected. Check the Review tab in Excel: if the button shows Unprotect Sheet, the sheet is protected.
Can I add the padlock icon back with a registry setting or VBA?
There is currently no supported setting or official option to restore the former padlock icon. Avoid unsupported registry or VBA workarounds and submit feedback through the Excel feedback forum instead.
Why did Microsoft remove the padlock icon?
Microsoft changed the protected-sheet tab indicator intentionally in Excel for Windows. It is not a workbook-specific issue or a sign of file corruption.
Will the padlock icon return in a future Excel update?
Only Microsoft can decide whether to restore it. You can submit feedback or vote for a visual protection indicator request in the Excel feedback forum to influence future updates.
Does WPS Spreadsheet show protected sheet indicators?
WPS Spreadsheet provides visible sheet protection controls and opens Excel workbooks, so you can check or apply protection while editing .xlsx files.




