Fix Excel Online Protected Sheet Disabling Font and Alignment Formatting
Question details
User needs to restore font, alignment, and number formatting controls in an Excel workbook when Excel for the web disables them on a protected worksheet.

- Product
- Microsoft Excel Online / WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user opened a protected worksheet in Excel for the web and found formatting controls unavailable, although the same file works in desktop Excel.
- Observed behavior
- Font, alignment, and number-format controls are disabled or grayed out while the worksheet is protected.
Confirm the worksheet is protected by checking the Review tab or status bar. If you have the password and permission to change protection, keep it ready before opening the file in a desktop spreadsheet application.
Open the workbook in WPS Office Spreadsheets to restore formatting controls
Use this solution when you need a desktop spreadsheet editor that can open the Excel file and give you familiar font, alignment, and number formatting tools without depending on Excel for the web.
WPS Office Spreadsheets opens .xlsx workbooks and provides desktop formatting controls on the Home tab. If the worksheet remains protected, you can use the Review tab to unprotect it first, just as you would in desktop Excel.
Install WPS Office, open WPS Spreadsheets, and click Menu > Open to select the Excel workbook.
Click the Review tab, choose Unprotect Sheet, and enter the password if prompted.
Select the target cells, then use the Home tab controls for font, alignment, and number format.
Click Menu > Save As and choose .xlsx to keep compatibility with Microsoft Excel.
Unprotect the sheet directly in Excel for the web or desktop Excel
Use this solution when you prefer to stay in Microsoft Excel and have permission to remove sheet protection.
Use WPS Office Spreadsheets to Edit Protected Excel Worksheets with Full Formatting Controls
Open your Excel workbook in WPS Office Spreadsheets on desktop, unprotect the sheet, and restore font, alignment, and number formatting tools. WPS Office preserves .xlsx compatibility and gives you a familiar ribbon interface for a smooth switch from Microsoft Excel.
- 1. Download WPS Office: Download and install WPS Office from the official WPS website.
- 2. Open the workbook in WPS Spreadsheets: Launch WPS Spreadsheets and open the .xlsx file from your computer or cloud storage.
- 3. Remove sheet protection: Click Review > Unprotect Sheet and enter the password if the sheet is protected.
- 4. Edit formatting: Use the Home tab to change font, alignment, and number formats.
- 5. Save in Excel format: Save the file as .xlsx to maintain Microsoft Excel compatibility.

Frequently Asked Questions
Why are font and alignment grayed out in Excel Online when my sheet is protected?
Excel for the web has a known limitation: protected worksheets can disable font, alignment, and number-format controls even if the same file allows those actions in desktop Excel. The controls return after you unprotect the sheet or open the file in a desktop spreadsheet application such as WPS Spreadsheets.
Can I format a protected sheet without removing protection in Excel Online?
In Excel for the web, there is currently no built-in way to keep the sheet protected and enable the disabled formatting controls. You need to unprotect the sheet or use a desktop application that supports the formatting actions.
Does WPS Office support Excel files with protected sheets?
Yes. WPS Office Spreadsheets opens .xlsx workbooks and provides Review tab options to unprotect a sheet. After unprotecting, you can change font, alignment, and number formatting using the Home tab.
Will saving from WPS Office break my Excel workbook?
No. You can save the file as .xlsx in WPS Office to keep full compatibility with Microsoft Excel, including formulas, formatting, and workbook structure.
Do I need a password to unprotect the sheet?
If the sheet is protected with a password, you will need the password. If no password was set, you can unprotect it directly from Review > Unprotect Sheet.




