How to adjust line spacing in excel

php editor Xinyi shares how to adjust line spacing in Excel. In Excel, the setting of line spacing can help us display the data content more clearly and improve the readability of the table. With simple operations, we can easily adjust the row spacing in Excel tables to make the data more tidy and beautiful. Next, let us learn how to adjust line spacing in Excel.

1. First, we create and open an excel table. We simply edit it to facilitate demonstration operations!

#2. Facing the text in the cell, the simple operation to adjust the line spacing is to hold down "alt enter" to force a line break.

#3. Then right-click with the mouse and select "Format Cells".

#4. In the "Alignment" interface, set both horizontal and vertical alignment to dispersed alignment, click OK, the text will be dispersedly aligned, and the line spacing will change accordingly.

#5. Next, we adjust the row height of the cell to adjust the distance between the rows.

Of course, there is another way.

1. We can also click the "文" button icon in the toolbar and select "Show Pinyin Field".

#2. After clicking, the text line spacing will become relatively larger.

In short, there is no one way to set row spacing in excel. You can choose a more appropriate or faster processing method according to the actual table situation. If you have not done anything similar yet, , be sure to practice and operate step by step according to the methods we share!

The above is the detailed content of How to adjust line spacing in excel. For more information, please follow other related articles on the PHP Chinese website!