ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I enter multiple paragraphs in a single Excel cell? (https://www.excelbanter.com/excel-discussion-misc-queries/93190-how-can-i-enter-multiple-paragraphs-single-excel-cell.html)

dclink9

How can I enter multiple paragraphs in a single Excel cell?
 
In a single Excel cell I am trying to include multiple paragraphs of text
which have a blank line between the paragraphs. For example, cell A1 has
item number '1000' and an associated detailed description. I am only able to
enter the description across multiple rows which does not support the
multiple sorting requirements of the spreadsheet. Ideas??

SimonCC

How can I enter multiple paragraphs in a single Excel cell?
 
Alt-Enter will take you to the next line within a cell.

-Simon

"dclink9" wrote:

In a single Excel cell I am trying to include multiple paragraphs of text
which have a blank line between the paragraphs. For example, cell A1 has
item number '1000' and an associated detailed description. I am only able to
enter the description across multiple rows which does not support the
multiple sorting requirements of the spreadsheet. Ideas??


ed

How can I enter multiple paragraphs in a single Excel cell?
 
Use Alt-Enter for a carriage return (paragraph) and 2 of them for the
seperation you want. ed

dclink9 wrote:
In a single Excel cell I am trying to include multiple paragraphs of text
which have a blank line between the paragraphs. For example, cell A1 has
item number '1000' and an associated detailed description. I am only able to
enter the description across multiple rows which does not support the
multiple sorting requirements of the spreadsheet. Ideas??




All times are GMT +1. The time now is 01:54 AM.

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