See all How-To Articles

How to Use Line Spacing in Excel

This tutorial demonstrates how to use line spacing in Excel.

 

line spacing initial data 1

 

Increase Line Spacing in a Cell

In Excel, text in a cell is often hard to read because of its vertical alignment. Say you have the following bottom-aligned text in cell B2.

 

line spacing initial data 1

 

In this case, you would probably want your text to be equally distributed vertically in the cell.

1. Select a cell with text (in this example B2), and in the Ribbon, go to the Home tab, and click on the Alignment Settings icon in the bottom right corner of the Alignment group. (Alternatively, you could right-click the cell and choose Format Cells…)

 

line spacing 1

 

2. In the Format Cells window, choose Justify in the Vertical drop-down list and click OK.

 

line spacing format cells

 

As a result, the text in B2 is now justified with equal spacing between lines.

 

line spacing final