How to print 2000+ characters seen in formula bar?

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

Guest

I have more than 1024 characters in one cell. I can see the complete text in
the formula bar but I cant print it
 
Hi
enter some manual linebrekas with ALT+ENTER every 1000 characters
 
Actually a cell can only display a maximum of about 1000 characters. It's
just a limitation in Excel. (Frank knows this but he's tired from not
sleeping for the last 6 months<g>).

--
Jim Rech
Excel MVP
|I have more than 1024 characters in one cell. I can see the complete text
in
| the formula bar but I cant 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 and changed it to a value.)

Adjusted the columnwidth and rowheight (autofit didn't work) and saw all
6037 characters in the cell and in printpreview. (I didn't actually test
printing.)
 
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? 5
Microsoft Excel Cell text limits 3
How do I get more than 255 characters into a cell? 3
Extra characters appear in the formula bar but not in the cell 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Hidden characters in formula bar in Excel 2007 9
Maximum Text in Cells for Printing 1
Max number of characters in a cell 1

Back
Top