Do you know Excel lets you store data into cells and each cell has 96 pixels of width and 24 pixels of height?
Each cell lets you add one or two words to it and sometimes you need to add a paragraph in Excel. What would you do? How to add paragraph in Excel? For this purpose, you can use a few tricks that let you add an entire paragraph in Excel easily. Let’s see how you can do it:
How to Add Paragraph in Excel with ALT Key in Excel Cell?
With the help of the ALT key, creating a line break is not a big deal. Writing a paragraph is easy with the line break. Below are simple steps to follow:
- First, you need to enter remarks in the Remarks column. And here in this example, you can see the remarks of John.
- Choose the E5 cell and start writing.
- Consider the column width while writing.
- Now, press the ALT + ENTER keys to move on to the next line in the same cell.
- Your cursor is on the next line. Now, you can write the remaining words.
- Once you are done writing a few words, move on to the next line.
- Write words in a single line as per the column width.
- Once again press ALT + ENTER keys to move on to the next line.
- Now, you can witness the remarks John is finished.
- Press ENTER key once the writing is finished and the editing mode will deactivate.
- It is time to adjust the cell height so that your entire paragraph could appear in the cell.
- For this, move the cursor on the division line between two rows and double-click on it.
- Eventually, you will notice the entire paragraph is in the E5 cell.
Likewise, you can now add the remarks of other employees as well.
How to Add Paragraph in Excel with Wrap Text in a Single Cell?
In this method, you will use the wrap text feature of Excel to add a paragraph in a single cell. Follow the steps given below to understand the complete procedure:
- Choose the cell in which you need to add a paragraph.
- You can either paste or write the paragraph you need to add. At first, the text will appear as overflowing from the cell.
- Now, edit the width and height of the cell to adjust the entire text in a single cell.
- Now, open the Home tab and choose the alignment group.
- Click on the wrap text option from the alignment group. It will wrap all the text in the cell.
- Using this method enables you to turn a lengthy text into a paragraph in the cell. When the width and height of the cell change, you will notice the paragraph in the cell also changes.
How to Add Paragraph with Fill Justify?
The Fill justify is the key option when you need to make a single paragraph while having values in more than one cell. Let’s understand this procedure with an example given below. In this example, three cells have values A1, A2, and A3.
- First of all, you need to adjust the column width so that all the values can be merged into one cell. And here the width changes to 2125 pixels.
- Now, choose all three cells with value in it.
- Open the Home tab and click on the Fill drop-down menu.
- Choose the Justify option.
- You will notice all the values in three cells are merged into a single cell.
- Click on the Wrap Text option and edit the width and height of the cell so that it can accommodate the paragraph.
Final Words:
In this post, you have learned how to add paragraph in Excel with the help of the Fill justify, ALT key, and Wrap text feature. All these methods are worthy enough to practice that’s why don’t feel hesitate while using these methods. You can easily convert any long text or sentence into paragraph form.
