Formatting Issues

How to Fix Excel Text That Only Appears After Double-Clicking

Adam Davis Oct 9, 2026 869 views

Question details

The user needs to fix an issue where text inside Excel cells is cut off or hidden, and only becomes fully visible when the cell is double-clicked to enter edit mode.

How to Fix Excel Text That Only Appears After Double-Clicking

Product: Excel
Device & OS: not provided
Scenario: Viewing or editing cells that contain long text strings exceeding the default column width or row height.
Observed behavior: Text in several Excel cells is not fully visible on the spreadsheet; the complete text only appears when the user double-clicks the specific cell.

Before you start

Ensure that your worksheet is not protected with a password, as cell formatting options like Wrap Text and AutoFit may be grayed out in locked sheets.

Solution 1Recommended

Enable Wrap Text and AutoFit Row Height

This is the most effective method to display long text within a single cell across multiple lines without having to alter the width of your columns.

When text is longer than the cell width, Excel either lets it spill into the adjacent empty cell or hides the excess if the adjacent cell is occupied. Wrapping the text forces it to expand vertically.

Select the affected cells

Click and drag your mouse to highlight the specific cells, rows, or columns where the text is currently hidden.

Enable Wrap Text

Navigate to the 'Home' tab on the top ribbon. Locate the 'Alignment' group and click on the 'Wrap Text' button. The text will now drop to a new line within the same cell.

AutoFit Row Height

If the cell height did not adjust automatically and the text is still cut off at the bottom, stay on the 'Home' tab. Click 'Format' in the 'Cells' group, and select 'AutoFit Row Height'.

Quick Shortcut: You can quickly auto-fit a row's height by moving your cursor to the row numbers on the left and double-clicking the bottom border of the affected row.

Solution 2

Widen the Column to Fit the Text

If you prefer the text to remain on a single continuous line instead of wrapping into multiple lines, you should expand the column width.

Manage Spreadsheets Easily

Fix Hidden Cell Text Easily with WPS Office

WPS Office offers a powerful, intuitive spreadsheet tool that flawlessly handles cell formatting, text wrapping, and row adjustments, ensuring your data is always presented clearly without hassle.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
2. Select your cells: Highlight the cells containing the hidden or cut-off text.
3. Apply Wrap Text: Go to the Home tab and click the 'Wrap Text' icon to make all content visible across multiple lines.
4. AutoFit the Rows: Click 'Row and Column' under the Home tab and choose 'AutoFit Row Height' to finalize the layout.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.One-click 'Wrap Text' and 'AutoFit' features to manage long cell contents effortlessly.Free, lightweight, and fast-loading alternative to heavy spreadsheet software.Familiar user interface requiring no learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Can I apply AutoFit to the entire worksheet at once?

Yes. Click the 'Select All' triangle in the top-left corner of the worksheet (where the row numbers and column letters intersect), then go to Home > Format > AutoFit Row Height. This will automatically adjust all rows in the sheet.

Why does AutoFit row height not work on merged cells?

Excel's AutoFit feature does not automatically adjust row heights for cells that have been merged. To display all text in a merged cell, you will need to manually adjust the row height by clicking and dragging the bottom border of the row header.

Why is my text disappearing when I press Enter?

This usually happens if the row height is manually fixed to a small value and 'Wrap Text' is enabled, causing the text to be pushed below the visible area of the cell. Select the cell and apply 'AutoFit Row Height' to resolve the issue.

Document & File Issues