insert a paragraph break within text in a singel cell?

G

Guest

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

Gord Dibben

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
 

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

Allow spaces between lines of text within cell 1
Import text to Excel 2
How can I enter multiple paragraphs in a single Excel cell? 2
Wrapping text with line breaks problem 1
Separate Paragraphs in a cell? 4
Pasting mutiple paragraph text into a single cell 2
How do I add a make a new paragraph in a text cell? 1
Can Excel enter page breaks to always follow a merge cell? 1

Top