How can I display and print more than 1024 characters in a cell?

L

Lisa

I have Excel 2003 and would like to print with more than 1024 characters in a
cell. Currently any characters beyond the 1024 characters are not displayed
under the 'wrap text' function.
Thank-you
 
R

Roger Govier

Hi Lisa

If you use Alt+Enter at intervals within the text that you are typing
within a cell, this will force a line feed.
Not only does this make large amounts of text more readable, it will
also permit you to display more than 1024 characters.
 

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

printing more than 1024 characters in a cell 10
Autocopy the first cell with more than 30 characters to a different sheet? 1
Text wrap spec 4
Find next cell with more than 1024 characters 3
Excel text export limit - 1024 per line (not cell), workaround? 11
Max characters in a cell work-around 0
Limits of Substitute and Replace functions 4
How to create a bubble chart with more than 2 variables. 0

Top