How To Clean White Space In Excel For Mac

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More...Less

Y'all might want to improve the look of the text within a cell by irresolute the vertical line spacing. Although Excel offers no direct control for line spacing inside a cell, you can apply several text alignment strategies to adjust white space or make the text more readable. Y'all can likewise add together a text box, which offers more command.

Tight the spacing for text inside a jail cell

If your text inside a prison cell is too widely spaced, it might be vertically justified. You can often better readability by changing the Text alignment to get the lines closer together.

Right-click inside the cell you want to change, and click Format Cells.
On the Alignment tab, change Vertical to Top, Center, or Bottom, depending on where you want your text to exist placed inside the cell.
Click OK.

Your text is at present aligned and evenly spaced where y'all wanted it.

Tip:If you accept lots of white infinite in one cell because another cell on the same row has more than content, yous can change the vertical alignment for the cell with too much infinite to Center to fill the space more evenly.

Meridian of Page

Increase the spacing for text in a cell

If your prison cell has white infinite, and y'all want to increment the line space to fill information technology evenly, change the vertical spacing to Justify.

Right-click in the cell you want, and click Format cells.
On the Alignment tab, change Vertical to Justify.
Click OK.

Your text is at present distributed evenly inside the cell. If you change the height of the row, the text re-adjusts evenly to the new width.

Top of Page

Supervene upon the text in a cell with a text box

If yous take only few cells with text that need to be modified, you lot tin consider inserting a text box on top of the prison cell. Past using a text box instead of a prison cell, you have more command over text formatting.

Double-click the cell you want to change, select all of the text in information technology, and printing Ctrl+X.
Click another cell to deselect the jail cell.
Arrange the superlative of the row, if needed.
On the Insert tab, click Text Box.
Move the cursor to the upper-left corner of the jail cell you want, and click and hold to draw a text box that fits the prison cell. If you lot need to accommodate the size of the text box after creating it, drag the selection squares at the edges.
Click in the text box to activate information technology, and press Ctrl+Five to paste your text within the text box.
Select all of the text in the text box, right-click it, and click Paragraph.
Select the line spacing you want.

Tip:You tin can besides tighten the text by reducing the font size. Select the text, and then right-click on information technology, click Font, and select the font size y'all desire.

Note:The text box is not within the jail cell but floats over information technology. If the row on which it was inserted moves equally the content in a higher place is changed, the text box does not movement forth with the cell. To motility the text box, motion the cursor to the edge of the text box, and click and concur to elevate the text box to a new location.