How to Use Line Spacing in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on March 4, 2023

This tutorial demonstrates how to use line spacing in Excel and Google Sheets.


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 might want your text to be equally distributed vertically in the cell.

  1. Select the text cell (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


  1. In the Format Cells window, choose Justify in the Vertical drop down 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


Line Spacing in a Text Box

You can also insert a text box into your Excel worksheet and adjust the line spacing within that shape.

  1. In the Ribbon, go to Insert > Text > Text Box.


linespacing ribbon textbox


  1. Then, draw the text box and enter your text.


linespacing textbox


  1. Select all the text in the text  box and then right-click. Then select Paragraph…


linespacing quick menu


  1. Change the After Spacing to 6pt.


linespacing paragraph after spacing


  1. Click OK to apply the changes.
  2. Then, with the text still selected (or select all of the text again), right-click once again and select Paragraph.  This time, choose an option from the Line Spacing drop down (e.g., 1.5 lines).


linespacing select spacing


  1. Click OK to apply the formatting to the text box.


linespacing one point five


Line Spacing in Google Sheets

You cannot change the line spacing in a cell in Google Sheets, but you can change it in a text box.

  1. In the Menu, go to Insert > Drawing.


linespacing gs insert drawing


  1. Select Text box and draw a text box into your drawing.


linespacing gs insert text box


  1. Type in your text.


linespacing gs textbox type


  1. In the Toolbar, click the line spacing button and choose a spacing option (e.g., 1.5). Then click Save and Close.


linespacing gs change spacing


  1. Your text box is then displayed in your Google Sheet with the chosen line spacing applied.


linespacing gs textbox

AI Formula Generator

Try for Free

See all How-To Articles