text gets cut in cells

D

D B Kaufmann

when trying enter text in a cell (say the size of a
letter for example) the text gets cut; only the cut
version is printable, although the formula bar displays
the whole text. How can I get all the text displayed in
the cell (AND printed)?
 
B

Bob Umlas

Cells can only print about 1024 characters, even tho they can contain about
32000 characters. In order to print/see more, use a text box.
Bob Umlas
Excel MVP
 
D

Dave Peterson

You can add a few (lots) of alt-enters in the cell to force linebreaks.

Then you can see more than excel's documented 1024 characters.

Depending on the font you use, you may be able to read it when you print it!

I put this in A1 of a test workbook:
="yyy"&CHAR(10)&REPT(REPT("asdf ",40)&CHAR(10),30)&"xxx"
(set it for wraptext)

Adjusted the columnwidth and rowheight and saw all 6037 characters in the cell
and in printpreview. (I didn't actually test printing.)
 

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

text gets cut in cells 3
cut and paste format problem 4
How do I fix text wrapping in Excel? 1
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. 3
paste text into cell that already has text in it 2
How do I print all the text in a cell 4
End of column 2
Text Not Showing in Cell 2

Top