Formatting Issues

Fix Wrapped Text and Extra Spaces in Excel Cells

Huda QurayshiHuda Qurayshi Nov 18, 2026 869 views

Question details

Create properly aligned, wrapped text in Excel cells without using extra spaces for positioning.

Fix Wrapped Text and Extra Spaces in Excel Cells
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to arrange text on multiple lines within a cell and keep it aligned when the cell size changes.
Observed behavior
Text is positioned with spaces, which can produce inconsistent alignment when column width or row height changes.
Before you start

Open the worksheet and identify the cells where spaces are being used to position text. Check whether the column is wide enough and the row is tall enough to display the intended lines.

Solution 1Recommended

Use Wrap Text and manual line breaks in Excel

Use this method to place text on separate lines within a cell and align it without padding spaces.

1
Enable text wrapping

Select the affected cells, then choose Home > Wrap Text.

2
Remove positioning spaces

Double-click a cell or select it and press F2, then delete extra spaces used to push text into position.

3
Insert line breaks

Place the cursor where a new line should begin. Press Alt+Enter on Windows, or Option+Command+Enter on many Mac keyboards.

4
Set alignment and size

Select the cells and use the alignment controls on the Home tab. Adjust the column width or row height by dragging the column or row boundary so all lines are visible.

Use Wrap Text and manual line breaks in Excel
Mac shortcuts may vary: If Option+Command+Enter does not insert a line break in your Excel version, try Control+Option+Return.
Work with wrapped cells in WPS

Align and wrap spreadsheet text in WPS Office

Use WPS Spreadsheet to open a workbook, remove positioning spaces, and format cell text with wrapping and manual line breaks.

  1. 1. Open the workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Turn on wrapping: Select the cells and choose Home > Wrap Text.
  3. 3. Edit the cell text: Double-click a cell, remove spaces used for positioning, and press Alt+Enter on Windows where you want a new line.
  4. 4. Adjust the layout: Use the Home tab alignment controls, then drag row or column boundaries to display the wrapped text.
  5. 5. Save the workbook: Choose File > Save or Save As and select an Excel format such as XLSX.
Wrap and align text within spreadsheet cellsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar ribbon interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How do I start a new line inside an Excel cell?

Edit the cell and place the cursor at the break point. Press Alt+Enter on Windows; on a Mac, try Option+Command+Enter or Control+Option+Return.

Why is some wrapped text hidden in my cell?

The row may be too short. Select the row and drag its lower boundary downward, or use the row height options on the Home tab to fit the text.

How can I align cell text without adding spaces?

Select the cells and use the horizontal and vertical alignment controls on Excel's Home tab. Insert manual line breaks where separate lines are needed.

Can WPS Spreadsheet edit an Excel workbook with wrapped text?

Yes. Open the XLSX or XLS file in WPS Spreadsheet, select the cells, and use Home > Wrap Text and the alignment controls. Save the workbook in an Excel format when finished.