| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wrapping in Excel (fitting many lines of text in cell to print rig
I know it is too late to help you, GUITRIS. But one of the user in the company had the same situation as you while she type a whole bunch of text in one cell on many lines (using alt +enter), the format is text, and tried to resize the cell left,right,up,down already, but still couldn't display all of the text in the cell, and it will only display #### in the cell. Then out of luck, I tried to use special as the format for the cell, and it display all the text that was enter in the cell, no matter how many lines. Even it is too late to help you, GUITRIS. But I hope it will help others that will have this situation in future. Because it took quite awhile for me to find this solution out. Best of luck!!! -- hd3017 ------------------------------------------------------------------------ hd3017's Profile: http://www.excelforum.com/member.php...o&userid=29428 View this thread: http://www.excelforum.com/showthread...hreadid=271383 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrapping in Excel (fitting many lines of text in cell to print rig
Even formatting as General would work.
hd3017 wrote: I know it is too late to help you, GUITRIS. But one of the user in the company had the same situation as you while she type a whole bunch of text in one cell on many lines (using alt +enter), the format is text, and tried to resize the cell left,right,up,down already, but still couldn't display all of the text in the cell, and it will only display #### in the cell. Then out of luck, I tried to use special as the format for the cell, and it display all the text that was enter in the cell, no matter how many lines. Even it is too late to help you, GUITRIS. But I hope it will help others that will have this situation in future. Because it took quite awhile for me to find this solution out. Best of luck!!! -- hd3017 ------------------------------------------------------------------------ hd3017's Profile: http://www.excelforum.com/member.php...o&userid=29428 View this thread: http://www.excelforum.com/showthread...hreadid=271383 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrapping in Excel (fitting many lines of text in cell to print rig
Actually, after your reply. I tried it out, but actually almost any other type of format display all the text in the cell! "Even date format!!!"  Thank you.-- hd3017 ------------------------------------------------------------------------ hd3017's Profile: http://www.excelforum.com/member.php...o&userid=29428 View this thread: http://www.excelforum.com/showthread...hreadid=271383 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrapping in Excel (fitting many lines of text in cell to print rig
Excel has trouble displaying strings that are between 255 and 1024 characters
long in cells formatted as text. Only MS knows for sure why. hd3017 wrote: Actually, after your reply. I tried it out, but actually almost any other type of format display all the text in the cell! "Even date format!!!" Thank you.-- hd3017 ------------------------------------------------------------------------ hd3017's Profile: http://www.excelforum.com/member.php...o&userid=29428 View this thread: http://www.excelforum.com/showthread...hreadid=271383 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get multiple lines of text in a Excel cell? | Excel Discussion (Misc queries) | |||
| A cell in an excel spreadsheet that does not print but shows in pr | Excel Discussion (Misc queries) | |||
| I have text in an Excel Cell that isn't showing all of it? | Excel Discussion (Misc queries) | |||
| How do I print all the text in a cell | Excel Discussion (Misc queries) | |||
| Set "print all text as black" as default in Excel | Excel Worksheet Functions | |||
Linear Mode
