Spacing lines in Excel

In the process of editing Excel file, sometimes the lines are not spaced as expected or the lines are not spaced evenly. So you want to evenly line the data in Excel. The following article will guide the line spacing in Excel.

Spacing lines in Excel Picture 1

Here are the line spacing in Excel, please follow along.

Option 1 : Select the lines that need to be indented in Excel (can be 1 line or adjacent lines or non-adjacent lines) and move the mouse to the number of lines and stretch at one position.

Spacing lines in Excel Picture 2

So all the lines you choose will be stretched the way you adjust them.

Spacing lines in Excel Picture 3

Method 2 : Select the lines that need to be indented in Excel (it can be 1 line or adjacent lines or non-adjacent lines), right-click and select R ow Height.

Spacing lines in Excel Picture 4

Or you choose Home -> Format -> Row Height.

Spacing lines in Excel Picture 5

The Row Height dialog box appears, enter the size you want to stretch and click OK to close the dialog box.

Spacing lines in Excel Picture 6

So all the lines you choose will be spaced the same.

Spacing lines in Excel Picture 7

Method 3: Automatic line spacing.

Select the lines that need to be stretched in Excel (can be 1 line or adjacent lines or non-adjacent lines), next you choose Home -> Format -> AutoFit Row Height.

Spacing lines in Excel Picture 8

So automatically line will be spaced in words in the line you choose.

Spacing lines in Excel Picture 9

Above are the line breaks in Excel, you can choose the fastest and most appropriate line spacing. Hope this article will help you. Good luck!