How to Fix Cannot Format or Edit Data After Combining Excel Sheets in WPS Office
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.

- 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 troubleshooting, confirm that you can open the file in a desktop spreadsheet application and check whether the worksheet or table is protected.
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.
Launch WPS Spreadsheets or Microsoft Excel desktop, click Menu or File > Open, and select the workbook that contains the combined data and table.
Click any cell inside the table, then try changing alignment, number format, or a formula to see whether the behavior returns to normal.
If formatting and formulas work correctly, continue editing in the desktop version and save the file as .xlsx so the table formatting is preserved.

Clear Existing Formatting and Verify the Worksheet or Table Is Not Protected
Use this when the issue also appears in a desktop spreadsheet application, because leftover formatting or protection can block editing.
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. Download WPS Office: Go to the official WPS Office website, download WPS Office Free, and install it on your computer.
- 2. Open the combined workbook: Launch WPS Spreadsheets, click Menu > Open, and choose the .xlsx workbook that contains your combined data and table.
- 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. Save as an Excel-compatible file: Click Menu > Save As, select .xlsx format, and save the workbook to preserve table formatting and formulas.

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.




