How can I enter multiple paragraphs in a single Excel cell?

D

dclink9

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??
 
E

ed

Use Alt-Enter for a carriage return (paragraph) and 2 of them for the
seperation you want. ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

insert a paragraph break within text in a singel cell? 3
Can Excel enter page breaks to always follow a merge cell? 1
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
How do I insert a row (space) between bulleted (#) paragraphs? 3
How Do I Replace Paragraphs With New Paragraphs In Excel? 8
Excel 2007 compatibility issue - speed between cells 2
Multiple paragraphs with paragraph spacing in a single table cell 1
Dividing worksheet into multiple workbooks 3

Top