Excel Line Spacing: How to Adjust Line Spacing (2024)
Sometimes, you may need to input a long text into your Excel spreadsheet.
When you do, you need to make sure that it’s organized and presentable, not only for your sake but for others as well😊
One of the many ways to do that is Line Spacing. Line spacing improves the overall presentation of your text in Excel.
In this lesson, you’ll learn how to adjust the line spacing in Excel so you can make your data more organized and presentable✨
Download this Excel workbook so you can learn and practice as we go on with the lesson.
Table of Contents
Adjust line spacing in a cell
Unlike Microsoft Word, there is no line spacing button in Excel.
But that doesn’t mean you can’t adjust the line spacing of text in Excel anymore.
Excel has a few tricks to help you make your text look so much better to read😉
To do that, you may increase the spacing between text lines.
It’s super easy. Just follow the steps below👇
- Select the cell with the text you want to adjust. In our example, it’s cell A1.
- Click the Home Tab.
- Click the Alignment settings icon.
Then, the Format cells dialog box will appear.
- In the Alignment Tab, click the drop-down arrow near the Vertical text alignment option to show alignment options.
- Choose the Justify option.
- Finally, click OK.
This is now the result.
The text is justified and aligned. There is equal spacing between the lines.
It looks better than before, don’t you think? 😊
There is another way to change the line spacing of text in Excel.
Adjust line spacing in a text box
Microsoft Excel also allows you to insert a text box into your spreadsheets.
A text box lets you add text anywhere in your Excel file without affecting your cells💬
As you can change the line spacing of your text in cells, you can do so in text boxes too.
Here’s how💪
- Go to the Insert tab.
- In the Text group, click the downward arrow to see Text options.
- Select Text Box.
- Draw a text box by dragging your cursor across the spreadsheet.
- Enter your text.
Then, select all the text in the text box.
- Right-click on the selected text and select Paragraph from the right-click menu.
The Paragraph dialog box will open.
- Now, change the line spacing to the way you want.
In this example, it’s 1.5 line spacing.
- Click OK.
This is now the result😊
The lines are not too close to each other.
Now, it looks more organized and presentable which makes it easier to read👀
Alternatively, you can use the Before and After spacing options where you have more line spacing text control.
Just repeat the steps shown above and change the line spacing😊
That’s it – Now what?
Neat work! 🙌
A simple change in line spacing can greatly change the overall look of your data. This makes you look more organized, more presentable, and more professional.
But we are barely covering how amazing and powerful Microsoft Excel is.
You can let Excel do the work with your data–from organization, computation, analysis, and visualization. You name it! Excel got you covered💪
First, you need to cover the basics of Excel as well. And I got you covered for that😊
Join my free online course where you’ll learn the basics of Excel and the core Excel functions: SUM, AVERAGE, and COUNT you shouldn’t miss out.
Other resources
If you want your Excel spreadsheets to look more organized, presentable, and professional, check out these articles for your next read:
By learning, you’ll excel in Excel in no time🚀