Sudipta Chandra Sarker
In this article, we will learn how to write a paragraph in an Excel cell. Sometimes we need to insert an entire paragraph in an Excel cell. We can easily write an entire paragraph in many ways. Today, we will show you 5 easy ways. So, without any delay, let’s start the discussion.
How to Write a Paragraph in Excel Cell: 5 Easy Ways
To demonstrate the method, we will use the dataset of the Performance of the employees of a Company. We will now write the Remarks of the members in the format of the paragraph. We will show you 5 easy ways of writing a paragraph in Excel cell.
1. Use ALT Key to Write a Paragraph in Excel Cell
Using the ALT key, you can create a line break in a single cell. By using the line break, you can write a paragraph. Let’s follow the steps to learn the method.
STEPS:
- We will write our remarks in the Remarks column.
- Firstly, we will write remarks of John.
- So, select the E5 cell and start writing.
- We will write according to the width of the column.
- So, after writing the following 3 words, we will press Alt + Enter to go to the next line in the same cell.
- So, the cursor is showing on the next line.
- After that, we will start writing the remaining words.
- After writing a few words, we need to go to the next line.
- We will write words in a single line according to the width of the cell.
- So, again press Alt + Enter to go to the next line.
- So, we have finished writing the remarks of John.
- After finishing the writing, press Enter to get out of editing mode.
- Now, we need to adjust the height of the cell to show the full paragraph of the cell.
- To do so, put the cursor on the division line between two rows and double–click it.
- As a result, you can see the entire paragraph in the E5Â cell.
- Similarly, write the remarks of the remaining employees of the company.
Read More: How to Make Text Automatically Wrap Around in Excel
2. Utilize Wrap Text Option to Make a Paragraph in Excel Cell
Utilizing the Wrap Text option in Excel, you can easily wrap the paragraph in a single cell. Let’s follow the steps to learn the method:
- Firstly, we will write our remarks about John whose performance is Good.
- So, select the E5 cell and write the Remark.
- In the following step, select the E5 cell and click on the Home tab of the workbook.
- Then, select Wrap Text from the Alignment group.
- Instantly, the paragraph is wrapped up in the E5Â cell.
- After that, you need to adjust the height of the cell to show the full paragraph of the cell.
- To do so, put the cursor on the division line between two rows and double–click it.
- As a result, you can see the entire paragraph in the E5Â cell.
- Similarly, write the remarks of the remaining employees of the company.
Read More: Wrap Text in Excel Shortcut Key
3. Apply Fill Justify Command to Type a Paragraph in Excel
Applying the Fill Justify command, you can easily type a paragraph in Excel. Let’s follow the steps to learn the method:
STEPS:
- Firstly, we will write our remarks about Ryan whose performance is Excellent.
- That’s why we need to insert some rows.
- We will insert the rows according to the length of the remarks.
- Here, we will insert 3 rows below the information of each employee.
- So, select a cell above which you want to insert a row.
- For this reason, we have selected the E6 cell and right-clicked on the mouse.
- Instantly, a pop-up menu appears and select Insert from there.
- After that, select the Entire row from the Insert window and click OK.
- Similarly, we will insert the rows where needed.
- As a result, you will see the results like the figure below.
- After inserting the rows, we will start typing paragraphs.
- So, select the E8 cell and write remarks about Ryan.
- After writing, select the Home tab.
- Then, select Fill >> Justify from the Editing group of the Home tab.
- Instantly, a message box will pop up and click OK to proceed.
- As a result, you can observe the paragraph of the remarks on performance of Ryan.
- Similarly, write the remarks of the remaining employees of the company.
Similar Readings
- How to Wrap Text across Multiple Cells without Merging in Excel
- Excel Auto Fit Row Height for Wrap Text
- Excel VBA Autofit Row Height with Wrap Text
- How to Wrap Text in Merged Cells in Excel
4. Write a Paragraph in Excel Cell Using Microsoft Word
We can easily type a paragraph in Excel with the help of Microsoft Word. Let’s follow the steps to learn the method:
STEPS:
- Firstly, we will write remarks about Matt.
- So, write the remark in the format which you want to show in the Excel Cell.
- For this reason, we will write the remark in the following format in MS Word.
- After writing, copy the remark by pressing Ctrl +Â C.
- Next, paste the remark into the Excel Cell.
- So, select the E7 cell and press Ctrl + V to paste the remarks.
- Then, press Enter to get out of editing mode.
- After that, you need to adjust the height of the cell to show the full paragraph of the cell.
- To do so, put the cursor on the division line between two rows and double–click it.
- As a result, you can see the entire paragraph in the E7Â cell.
- Similarly, write the remarks of the remaining employees of the company.
Read More: Excel VBA to Wrap Text
5. Use Text Box to Write a Paragraph in Excel Cell
Using the Text Box, you can easily write a paragraph in an Excel Cell.  Let’s follow the steps to learn the method:
STEPS:
- Firstly, go to the Insert tab of the Excel workbook.
- Then, select the drop-down menu of the Text.
- And, select Text Box from the floated wizard that appeared.
- Instantly, you will see an Anchor icon as shown below.
- Now, left–click and drag this icon to create a box on the E8 cell.
- Afterward, drag the radio button of the Text Box to adjust the size of the Text Box.
- Then type your required text inside it.
- Then, write the remarks on the performance of David.
- Similarly, write the remarks of the remaining employees of the company.
Download Practice Workbook
To practice by yourself, download the following workbook.
Conclusion
In this article, we have demonstrated how to write paragraphs in Excel cell. There is a practice workbook at the beginning of the article. Go ahead and give it a try. Last but not least, please use the comment section below to post any questions or make any suggestions you might have.
