Displaying / printing large amounts of cell text

lyano

New Member
Joined
Jan 21, 2005
Messages
2
A cell that contains a large amount of text does sometimes not display or print the full contents even after I set row height to auto fit. I must manually increase the row size to show all the text. Any help is appreciated.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

vconfused

Well-known Member
Joined
Jun 11, 2004
Messages
547
How much text are we talking? There is a limit of about 1024 characters that will print, which includes spaces. If using spaces to get text to the next line, try using Alt+Enter instead.

From Excel Help:
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

If this doesn't help, can you use the len() formula to determine the actual length in the cell?
 

lyano

New Member
Joined
Jan 21, 2005
Messages
2
The cells I have trouble with do contain more than 1024 characters. Is it true that Row / Autofit will not adjust the row height to display the total amount of text? Although making the column wider seems to help display more of the text. Is there a maximum row height within a column that I should be aware of when trying to fit more than 1024 characters of text? I found some additional related help that gave instructions to run a macro but I've never worked with macros before.
 

vconfused

Well-known Member
Joined
Jun 11, 2004
Messages
547
I believe it is more trial and error. I wouldn't get any hopes up in trying to continuously display more than 1024 characters. Can you break the data up into multiple cells? Perhaps insert a Word object?

Going back to Excel Help:
Column width 255 characters
Row height 409 points
 

Watch MrExcel Video

Forum statistics

Threads
1,129,804
Messages
5,638,455
Members
417,025
Latest member
MusterDuster

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top