Spacing lines in Excel

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 fish

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.

Picture 1 of Spacing lines in Excel

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.

Picture 2 of Spacing lines in Excel

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

Picture 3 of Spacing lines in Excel

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.

Picture 4 of Spacing lines in Excel

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

Picture 5 of Spacing lines in Excel

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

Picture 6 of Spacing lines in Excel

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

Picture 7 of Spacing lines in Excel

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.

Picture 8 of Spacing lines in Excel

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

Picture 9 of Spacing lines in Excel

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!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile