30 Advanced Excel Tips for 2026

Excel Champs / Range / How to Make Paragraph in a Cell in Excel
By Puneet Gogia (Microsoft MVP)

How to Make Paragraph in a Cell in Excel

In Excel, we have cells to enter and store data, and by default, a cell is only about 8.43 characters wide and one line high, so you can only show one or two words in it.

But sometimes you need to add an entire paragraph to the worksheet in Excel. For this, there are a few options that you can use.

cell-in-excel

In this tutorial, we will learn all those options.

Steps to Use Wrap Text to Add a Paragraph in a Single Cell in Excel

  1. First, select the cell where you want to enter the paragraph and edit it (press F2 or double-click the cell).
    select-the-cell
  2. Now, paste or type the text of the paragraph that you want to add, and that will look something like the following, where your text is overflowing from the cell.
    paste-or-type-paragraph-text
  3. Next, you need to change the width and height of the cell so that the entire text gets adjusted in a single cell.
    change-the-cell-size
  4. Afterward, go to the Home tab ➜ Alignment group, and click on the Wrap Text button to wrap the entire text in the cell.
    click-wrap-text-button

This way, you can turn a long text sentence into a paragraph in the cell. And when you change the width of the cell, the paragraph inside the cell re-wraps to fit the new width.

Type a Paragraph using a Line Break

If you want to type a full paragraph inside a cell, you can use a line break to shift to the new line within the cell. Once you complete a line, just use the keyboard shortcut Alt + Enter to insert a new line within the cell.

use-line-break-in-cell

With this keyboard shortcut, you can create as many line breaks within the cell as you need (on a Mac, use Option + Return). And, if you want to add multiple paragraphs, this method works better.

create-many-line-breaks

After each paragraph, you need to press the shortcut key twice: once to end the line and once more to leave a blank line before the next paragraph.

Use a Text Box to Add a Paragraph in Excel

In Excel, you can insert a text box and then add the paragraph text into it.

  1. First, go to the Insert tab, click the Text drop-down and click on Text Box.
    text-box-to-add-paragraph
  2. Next, click and drag on the worksheet to draw the text box.
  3. Now, edit the text box and paste or type the text in it.
    edit-text-box
  4. In the end, adjust the width of the text box. The text wraps inside it, and you can format it like text in Word.

Create a Paragraph using Fill Justify

Let’s say you have values in multiple cells, and you want to create a single paragraph. You can use fill justify for this. Fill Justify can combine values from multiple cells. In the following example, we have a value in three cells A1, A2, and A3.

paragraph-using-fill-justify

Now, to create a paragraph of these values in cell A1, first make your column wide enough so that all three values can be combined in a single cell. I have changed the width to 2125 pixels.

  1. Select all three cells.
  2. Go to the Home tab.
  3. Click on the Fill drop-down (in the Editing group).
  4. Select the Justify option.
select-justify-option

Now, you have all the values in a single cell. Click on the Wrap Text option and change the height and width of the cell to make it a paragraph.

Keep in mind that Fill Justify works only with text values (not numbers or formulas) in one column, and each combined cell can hold up to 255 characters. If the text doesn’t fit in the column width, Excel spreads it over the cells below.

Join Cells into a Paragraph with a Formula

If you want to keep the original cells and build the paragraph in another cell, use a formula. TEXTJOIN (Excel 2019 and later, and Microsoft 365) joins a range with a space and skips empty cells:

=TEXTJOIN(" ",TRUE,A1:A3)

And to put each value on its own line inside the cell, use CHAR(10) (the line break character) as the separator, and turn on Wrap Text for the result cell:

=TEXTJOIN(CHAR(10),TRUE,A1:A3)

In older versions, use the & operator instead:

=A1&CHAR(10)&A2&CHAR(10)&A3

Tips for Paragraphs in a Cell

  • Use merged cells for a wide paragraph: merge a few cells across and turn on Wrap Text. Just note that AutoFit Row Height doesn’t work on merged cells, so you need to set the row height yourself.
  • Align the text to the top: Home ➜ Alignment ➜ Top Align keeps the paragraph at the top of a tall cell, which is easier to read.
  • Check the spelling: press F7 to run the spell check on your text.
  • Know the limit: a cell can hold up to 32,767 characters.

Frequently Asked Questions

Why does Alt + Enter not show a new line?

The line break is there, but the cell needs Wrap Text turned on to show it. Excel turns it on for you when you type Alt + Enter, but not when the text comes from a formula or another file.

Why is my row height not adjusting to the paragraph?

Either the row height was set manually, or the cell is merged. Double-click the border below the row number to AutoFit it, or set the height from Home ➜ Format ➜ Row Height.

How do I remove the line breaks from a paragraph?

Use Find and Replace (Ctrl + H), press Ctrl + J in the Find what box to enter a line break, put a space in Replace with, and click Replace All.

wrap-text-and-set-cell-size

Leave a Comment