| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Info cut off in a cell
Hi, I can't figure out how to keep all of the info typed into a cell from
being cut off. The cell does have the wrap text on. I can get about 14 lines within the cell when the last line stops wrapping and just goes off to the right. Any suggestion??? Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Info cut off in a cell
The limit for # of character in a cell is 255. Perhaps you exceeded the limit
JH "Dave" wrote: Hi, I can't figure out how to keep all of the info typed into a cell from being cut off. The cell does have the wrap text on. I can get about 14 lines within the cell when the last line stops wrapping and just goes off to the right. Any suggestion??? Dave |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Info cut off in a cell
That hasn't been the limit for over a decade.
Excel says that you can have 32k characters in a cell but only 1k will appear in the worksheet. But you can exceed that limit by adding alt-enters (to force new lines within the cell) every 80-100 characters. JH wrote: The limit for # of character in a cell is 255. Perhaps you exceeded the limit JH "Dave" wrote: Hi, I can't figure out how to keep all of the info typed into a cell from being cut off. The cell does have the wrap text on. I can get about 14 lines within the cell when the last line stops wrapping and just goes off to the right. Any suggestion??? Dave -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Info cut off in a cell
Try adding alt-enters every 80-100 characters.
Dave wrote: Hi, I can't figure out how to keep all of the info typed into a cell from being cut off. The cell does have the wrap text on. I can get about 14 lines within the cell when the last line stops wrapping and just goes off to the right. Any suggestion??? Dave -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
| Move cell info and info in neighboring cell on new entry | Excel Discussion (Misc queries) | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) | |||
Linear Mode
