Office Settings & Configuration

Fix Excel Online Protected Sheet Disabling Font and Alignment Formatting

Muhammad TalhaMuhammad Talha Nov 13, 2026 868 views

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.

Fix Excel Online Protected Sheet Disables Font and Alignment Formatting
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.
Before you start

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.

Solution 1Recommended

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.

1
Download and launch WPS Office

Install WPS Office, open WPS Spreadsheets, and click Menu > Open to select the Excel workbook.

2
Unprotect the worksheet if required

Click the Review tab, choose Unprotect Sheet, and enter the password if prompted.

3
Apply font and alignment formatting

Select the target cells, then use the Home tab controls for font, alignment, and number format.

4
Save the workbook

Click Menu > Save As and choose .xlsx to keep compatibility with Microsoft Excel.

Formatting controls restored: After unprotecting the sheet in WPS Spreadsheets, font, alignment, and number format controls become active.

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. 1. Download WPS Office: Download and install WPS Office from the official WPS website.
  2. 2. Open the workbook in WPS Spreadsheets: Launch WPS Spreadsheets and open the .xlsx file from your computer or cloud storage.
  3. 3. Remove sheet protection: Click Review > Unprotect Sheet and enter the password if the sheet is protected.
  4. 4. Edit formatting: Use the Home tab to change font, alignment, and number formats.
  5. 5. Save in Excel format: Save the file as .xlsx to maintain Microsoft Excel compatibility.
Desktop formatting controls for font, alignment, and number format on protected Excel workbooksFull compatibility with Microsoft Excel .xlsx filesFree, lightweight Office suite with a familiar ribbon interfaceNo dependency on Excel for the web limitations or Microsoft 365 updates
microsoft office alternative - wps office

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.