Fix Wrapped Text and Extra Spaces in Excel Cells
Question details
Create properly aligned, wrapped text in Excel cells without using extra spaces for positioning.

- 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.
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.
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.
Select the affected cells, then choose Home > Wrap Text.
Double-click a cell or select it and press F2, then delete extra spaces used to push text into position.
Place the cursor where a new line should begin. Press Alt+Enter on Windows, or Option+Command+Enter on many Mac keyboards.
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.

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. Open the workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Turn on wrapping: Select the cells and choose Home > Wrap Text.
- 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. Adjust the layout: Use the Home tab alignment controls, then drag row or column boundaries to display the wrapped text.
- 5. Save the workbook: Choose File > Save or Save As and select an Excel format such as XLSX.

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.




