Office Compatibility Issues

How to Fix Cannot Format or Edit Data After Combining Excel Sheets in WPS Office

Steve KSteve K Nov 13, 2026 868 views

Question details

The user combined a large amount of data into one worksheet and converted it to a table, but formatting, alignment, and formula behavior do not work as expected, especially in Excel for the web.

How to Fix Cannot Format or Edit Data After Combining Excel Sheets in WPS Office
Product
Microsoft Excel for the web, Microsoft Excel desktop, and WPS Spreadsheets
Device & OS
not provided
Scenario
The user needs to manage a large dataset in a combined worksheet and retain control over table formatting, alignment, and formulas.
Observed behavior
Formatting and alignment do not respond as expected, and formulas may replicate automatically. The behavior occurs primarily in Excel for the web.
Before you start

Before troubleshooting, confirm that you can open the file in a desktop spreadsheet application and check whether the worksheet or table is protected.

Solution 1Recommended

Open the Workbook in WPS Spreadsheets or Excel Desktop to Restore Full Formatting and Editing

Use this first when Excel for the web is limiting formatting, alignment, or formula behavior after you merge data into a table.

Excel for the web has fewer layout and table controls than desktop spreadsheet applications. Opening the same workbook in WPS Spreadsheets or Microsoft Excel desktop can confirm whether the issue is web-specific and immediately restores the full formatting toolset.

1
Open the workbook in a desktop app

Launch WPS Spreadsheets or Microsoft Excel desktop, click Menu or File > Open, and select the workbook that contains the combined data and table.

2
Select the table and test formatting

Click any cell inside the table, then try changing alignment, number format, or a formula to see whether the behavior returns to normal.

3
Continue working in the desktop app

If formatting and formulas work correctly, continue editing in the desktop version and save the file as .xlsx so the table formatting is preserved.

Open the Workbook in WPS Spreadsheets or Excel Desktop to Restore Full Formatting and Editing
Desktop app restores full table controls: If the issue only appears in Excel for the web, the workbook itself is usually not damaged.
WPS Spreadsheets solution

Edit and Fix Combined Excel Worksheets with WPS Spreadsheets

Open the combined Excel workbook in WPS Spreadsheets to restore responsive table formatting, alignment, and formula control in a desktop environment, and save it as a Microsoft Excel-compatible .xlsx file.

  1. 1. Download WPS Office: Go to the official WPS Office website, download WPS Office Free, and install it on your computer.
  2. 2. Open the combined workbook: Launch WPS Spreadsheets, click Menu > Open, and choose the .xlsx workbook that contains your combined data and table.
  3. 3. Edit table formatting and formulas: Click inside the table, then use the Home tab to change alignment and number formats, and enter formulas without automatic calculated-column behavior.
  4. 4. Save as an Excel-compatible file: Click Menu > Save As, select .xlsx format, and save the workbook to preserve table formatting and formulas.
Full desktop formatting, alignment, and formula control for combined Excel worksheetsCompatible with Microsoft Excel .xlsx and .xls filesFree, lightweight, and easy-to-use spreadsheet interfaceAvoids Excel for the web table and formatting restrictions
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I format or edit data in Excel for the web after merging sheets?

Excel for the web has fewer table and formatting tools than desktop spreadsheet programs, and large merged tables can behave unexpectedly. Open the workbook in WPS Spreadsheets or Microsoft Excel desktop to restore full formatting and editing controls.

How do I stop formulas from replicating automatically in an Excel table?

This is the calculated-column behavior in Excel tables. In WPS Spreadsheets or Excel desktop, enter the formula, click the AutoCorrect Options button that appears, and choose Stop Automatically Creating Calculated Columns. You can also clear the column formatting if the auto-filled formulas remain.

How do I clear formatting in WPS Spreadsheets?

Select the cells or table area, go to the Home tab, click Clear, and choose Clear Formats. You can then reapply the alignment, number format, and table style you need.

What should I check if I still cannot edit the worksheet after opening it in desktop?

Check whether the worksheet or table is protected. In WPS Spreadsheets or Excel desktop, go to the Review tab and click Unprotect Sheet, or open Table Tools and click Unprotect Table. You may need to enter the password if one was set.