How to print 2000+ characters seen in formula bar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Formula bar shows +1024 characters, screen only shows 1024. Printer only
prints 1024. How can I print all?
 
Add some alt-enters to force new lines within the cell.

Use a smaller font.
Widen the column width
lengthen the row height.
 
Thanks, but none of your suggestions work. I'm using Excel 2003 by the way.
 
That's too bad.

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.
 
Yes, your formula worked for me too (after changing the commas to semicolons :)
I now see what the problem is. After about 1125 characters, the text stops
wrapping so I see much less text on screen. If you type in your formula and
then adjust the column width to less than the length of the sentence, you
can check if it happens to you too. Why does the wrap stop working? How can
I repair it? I don't want to have to manually type in Alt-enters according
to the width of the cell. I'm posting a new thread on that.
Thanks
 
You must log in or register to reply here.

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

How to print 2000+ characters seen in formula bar? 3
Microsoft Excel Cell text limits 3
Max number of characters in a cell 1
Error message is Character Limit is over 1024 characters 2
Chracter Limit Help!! 7
Display Size Limit In Single Cell 2
Is it possible to enter more than 255 characters in a cell 2
How many bytes there are in one gigbyte. 9

Back
Top