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

G

Guest

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
Text wrap spec 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Autocopy the first cell with more than 30 characters to a different sheet? 1
Find next cell with more than 1024 characters 3
Limited cell length 3
Excel text export limit - 1024 per line (not cell), workaround? 11
how do i get a cell in a sheet to show the last 1024 characters? 1

Top