ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   insert a paragraph break within text in a singel cell? (https://www.excelbanter.com/excel-discussion-misc-queries/112164-insert-paragraph-break-within-text-singel-cell.html)

Julie

insert a paragraph break within text in a singel cell?
 
I am trying to enter text in an excel spreadsheet. The text has multiple
paragraphs. I would like to have all text from one section in one cell and
not enter new paragraphs in multiple cells. Are there any manual commands I
can enter to perform this action?

ExcelBanter AI

Answer: insert a paragraph break within text in a singel cell?
 
Yes, you can insert a paragraph break within text in a single cell in Excel. Here's how:
  1. Double-click on the cell where you want to insert the paragraph break.
  2. Place your cursor where you want the paragraph break to occur.
  3. Press the "Alt" key on your keyboard and, while holding it down, press "Enter". This will insert a line break within the cell.
  4. Type in the text for the next paragraph.
  5. Repeat steps 2-4 for each additional paragraph.

Alternatively, you can also use the keyboard shortcut "Ctrl + Enter" to insert a line break within a cell. This will allow you to quickly add multiple paragraphs of text within a single cell.

By using these manual commands, you can easily insert paragraph breaks within text in a single cell in Excel. This will help you to keep all of your text in one cell and make it easier to manage and organize your data.

Kevin B

insert a paragraph break within text in a singel cell?
 
Press Alt+Enter to insert a new line withing a single cell.
--
Kevin Backmann


"Julie" wrote:

I am trying to enter text in an excel spreadsheet. The text has multiple
paragraphs. I would like to have all text from one section in one cell and
not enter new paragraphs in multiple cells. Are there any manual commands I
can enter to perform this action?


Julie

insert a paragraph break within text in a singel cell?
 
AWESOME...thank you so much! Have a great day!

"Kevin B" wrote:

Press Alt+Enter to insert a new line withing a single cell.
--
Kevin Backmann


"Julie" wrote:

I am trying to enter text in an excel spreadsheet. The text has multiple
paragraphs. I would like to have all text from one section in one cell and
not enter new paragraphs in multiple cells. Are there any manual commands I
can enter to perform this action?


Gord Dibben

insert a paragraph break within text in a singel cell?
 
Julie

Just don't try to get too much text into a cell.

You can enter up to 32,767 characters in a cell but only 1024 will be visible or
printed.

Add an ALT + ENTER every 100 chars to increase the 1024 limit.


Gord Dibben MS Excel MVP

On Fri, 29 Sep 2006 06:14:02 -0700, Julie
wrote:

AWESOME...thank you so much! Have a great day!

"Kevin B" wrote:

Press Alt+Enter to insert a new line withing a single cell.
--
Kevin Backmann


"Julie" wrote:

I am trying to enter text in an excel spreadsheet. The text has multiple
paragraphs. I would like to have all text from one section in one cell and
not enter new paragraphs in multiple cells. Are there any manual commands I
can enter to perform this action?




All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com