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

G

Guest

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
How do I add a make a new paragraph in a text cell? 1
How Do I Replace Paragraphs With New Paragraphs In Excel? 8
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
Cut and Paste Text with CRLF into Single Cell 1
Excel 2007 compatibility issue - speed between cells 2
Excel Query setup 0

Top