How to Fix Excel for the Web Cannot Change Cell Fill Color in a Protected Sheet
Question details
Users need a way to apply fill color to unlocked cells in a protected Excel workbook when using Excel for the web, because the main fill color control is unavailable or unresponsive.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- A protected workbook is opened in Excel for the web, and the user selects unlocked cells to format them with a fill color.
- Observed behavior
- The main fill color button cannot be used, but selecting a color from the fill color drop-down menu applies the color. The feature works normally in desktop Excel.
Confirm that the worksheet protection settings allow unlocked cells to be formatted, and open the workbook from its stored location such as SharePoint or OneDrive so the Excel for the web ribbon loads correctly.
Use the Fill Color drop-down menu instead of the main color button
Use this workaround when the main Fill Color control is disabled or unresponsive in a protected Excel for the web workbook.
Excel for the web may show the main Fill Color button as inactive when worksheet protection is enabled, even if unlocked cells are selected. The drop-down arrow next to the button often remains usable as a workaround.
Open the protected workbook in Excel for the web and select the unlocked cells where you want to change the fill color.
On the Home tab, click the arrow next to the Fill Color paint bucket button instead of clicking the main button.
Pick a color from the drop-down palette. The selected cells update immediately.
Raise a service request through the Microsoft 365 admin center
Use this if the drop-down menu workaround does not resolve the issue or you need an official fix from Microsoft.
Use WPS Spreadsheets to Edit Protected Excel Workbooks Without the Web Limitation
If Excel for the web blocks fill color formatting in protected sheets, WPS Office provides a free, lightweight alternative. WPS Spreadsheets supports Excel workbooks, keeps familiar formatting tools, and helps you migrate seamlessly while maintaining .xlsx compatibility.
- 1. Download WPS Office: Go to the official WPS Office website, download the free installer, and install WPS Office on your computer.
- 2. Open the Excel workbook: Launch WPS Spreadsheets and open the .xlsx file from your local drive, SharePoint, or OneDrive.
- 3. Change the cell fill color: Select the unlocked cells, go to Home, click the Fill Color drop-down arrow, and choose the color you need.
- 4. Save the workbook: Save the file in Excel format to keep it compatible with Microsoft Excel.
Frequently Asked Questions
Why is the Fill Color button unavailable in Excel for the web on a protected sheet?
This is a known Excel for the web limitation when worksheet protection is enabled. The main Fill Color button can appear disabled or unresponsive, but the drop-down arrow next to it often still works.
Can I change cell fill color without unprotecting the sheet?
Yes, in many cases you can select unlocked cells, open the Fill Color drop-down menu on the Home tab, and choose a color even if the main button cannot be clicked.
Does WPS Office open protected Excel workbooks?
WPS Spreadsheets can open .xlsx workbooks and respects Excel protection settings. If formatting is allowed for unlocked cells, you can use the Fill Color tool in WPS Office to change cell fill color.
Is this issue caused by WPS Office?
No. The behavior is reported in Microsoft Excel for the web, not WPS Office. WPS Office can be used as an alternative to edit the workbook locally.
How do I report this issue to Microsoft?
Sign in to the Microsoft 365 admin center with a global administrator account, search for support, and select Contact support to create a service request.
