HOME > Office programs > Excel: Insert Paragraph In Cell - How To Do It

Excel: Insert paragraph in cell - how to do it

If there are longer texts as content in the cells of your Excel tables, it may be necessary to interrupt them with a paragraph. How to insert such a paragraph manually or automatically in Excel, we show you in this tutorial step by step.

How to insert a paragraph into a cell in Excel

If you don't want the contents of your Excel cells to be displayed next to each other, Excel gives you the option to insert a line break. This breaks the text and displays the content in several lines below each other.
  1. To insert an automatic line break, first select the cells to be formatted in a worksheet.
  2. In Excel's menu bar, then navigate to the "Start" tab and click "Line Break" in the "Alignment" area.
  3. The data contained in the cells will now be wrapped to fit the column width and automatically adjusted when you change the column width.
  4. Alternatively to the automatic line break, you can also insert a manual line break in Excel. To do this, double-click on the corresponding cell, select the place where you want to insert the line break and press the "ALT" + "Enter" keys.

Paragraph in cell: How to adjust the cell height in Excel

Have you inserted a paragraph in a cell, it can sometimes happen that the wrapped text is not displayed completely. To fix this problem, it is necessary to adjust the cell's row height. To do this, select the cell, go to "Start" > "Cells" > "Format" and select one of the options "Automatically adjust row height" or "Row height".

By Blinnie Bynd

How does Western Union work? You should know :: FlashGet: Limit download speed
USEFUL LINKS