Formatting Issues

How to Fix Excel Cells Expanding or Displaying Text Incorrectly

WPS Editor Oct 1, 2026 868 views

Question details

The user needs to fix an issue where text appears to expand across a row or displays improperly while characters are being entered or deleted in a cell.

How to Fix Excel Cells Expanding or Displaying Text Incorrectly

Product: Excel
Device & OS: not provided
Scenario: Typing, editing, or deleting text data inside a specific spreadsheet cell.
Observed behavior: Text expands unexpectedly across the row or renders with incorrect formatting, often restricted to specific highlighted input cells.

Before you start

Check if your worksheet has a 'Protect Sheet' status enabled, as locked formatting will prevent you from altering alignment or unmerging problem cells.

Solution 1Recommended

Check and Reset Cell Alignment and Merged Ranges

Inspect the affected cells and remove any merged ranges, custom indentation, or unusual text rotation that causes the text to expand incorrectly.

Unusual text display is most commonly caused by hidden merged cells, custom orientation (text rotation), or heavy indentation settings applied to specific input cells.

Select the affected cell

Click on the specific highlighted cell where the text is expanding or displaying incorrectly.

Open Format Cells

Right-click the selected cell and choose 'Format Cells' from the context menu.

Navigate to the Alignment tab

In the Format Cells dialog, click on the 'Alignment' tab at the top.

Reset alignment settings

Ensure 'Merge cells' is unchecked. Set the horizontal and vertical text alignment to 'General' or 'Bottom', set 'Indent' to 0, and change the 'Orientation' degree dial to 0.

Apply changes

Click 'OK' to apply the clean alignment settings. Retype or delete characters to verify the cell behaves normally.

Check and Reset Cell Alignment and Merged Ranges

Tip: Checking the 'Wrap text' box in the same Alignment tab can also prevent long strings of text from spilling over into adjacent empty columns.

Solution 2

Clear Formats to Remove Hidden Styling

Wipe out all formatting rules applied to the cell and revert it to the default display state to resolve persistent visual glitches.

Solution 3

Test in an Unprotected Workbook Copy

Verify if workbook protection is causing the input behavior by testing the data entry in a fresh, unprotected file.

Seamlessly Manage Cell Formatting with WPS Office

Easily Fix Cell Display Issues in WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and intuitive interface to manage cell formatting, alignment, and merged ranges without unexpected text expansion issues.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing the incorrectly formatted cells.
2. Select the affected cells: Highlight the cells where text expands across the row.
3. Access cell formatting: Right-click the selection and choose 'Format Cells', then go to the 'Alignment' tab.
4. Adjust alignment and unmerge: Uncheck 'Merge cells', set Indent to 0, and click 'OK' to instantly fix the display issue.

Highly compatible with Microsoft Excel (.xlsx) file formatsIntuitive cell formatting and alignment controlsClear visual indicators for merged cells and wrapped textFree, lightweight, and fast spreadsheet solution

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel text go across multiple columns?

This happens when the text string is longer than the column width and the adjacent cells to the right are completely empty. The spreadsheet software visually spills the text over to ensure it is readable. You can prevent this by enabling 'Wrap Text' or by resizing the column width.

How do I stop cells from merging automatically?

Cells do not merge on their own, but copied data from the web or other documents might bring merged formatting with it. To fix this, select the affected area, go to the Home tab, and click the 'Merge & Center' button to toggle it off and unmerge the cells.

Why is my text rotating diagonally in the cell?

The text orientation setting has been altered. To fix it, right-click the cell, select 'Format Cells', navigate to the 'Alignment' tab, and adjust the Orientation degree dial back to 0 degrees.

Can worksheet protection cause cell display issues?

Yes. If a worksheet is protected, certain cells may be locked with specific formatting (like forced text rotation or indentation) that you cannot change. Typing into these locked formats can make the text appear as if it is displaying incorrectly.

Document & File Issues