Office Settings & Configuration

Why Excel Protected Sheet Padlock Icons Disappeared

John WilsonJohn Wilson Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in Excel

Open the affected workbook in Microsoft Excel for Windows.

2
Select the worksheet tab

Click the worksheet tab you want to check.

3
Check the Review tab

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.

Verify worksheet protection without the padlock icon
No supported restore setting: There is currently no supported Excel option to restore the former padlock icon on protected worksheet tabs.
Free Microsoft Office alternative

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. 1. Download WPS Office: Click Download WPS Office Free and install WPS Office on Windows.
  2. 2. Open your Excel workbook: Launch WPS Spreadsheet and open the .xlsx workbook you need.
  3. 3. Manage protection clearly: Select a worksheet and use Review > Protect Sheet to apply or check protection in WPS Spreadsheet.
Free Microsoft Excel alternative with no subscriptionOpens, edits, and saves .xlsx files with format compatibilityFamiliar ribbon UI simplifies migration from ExcelVisible sheet protection controls in WPS Spreadsheet
microsoft office alternative - wps office

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.