| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on cell contents
In Excel Help, it says that the...Length of cell contents (text) is limited
to 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. I need to be able to print all contents in a cell. Is there a way to do this by getting around this cell limitation? Thank you! -- Tina |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
limit on cell contents
If you put in hard character returns within the test string (alt+Enter)
you can get more then 1024 to display. In conjunction with that, you can reduce the font size as well if you are running up against the maximum size of the cell. -- Regards, Tom Ogilvy "Tina" wrote: In Excel Help, it says that the...Length of cell contents (text) is limited to 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. I need to be able to print all contents in a cell. Is there a way to do this by getting around this cell limitation? Thank you! -- Tina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
| how do I print the contents of a cell that is over the max limit? | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Excel Solver: How do I limit the contents of a cell to 1=True or 0 | New Users to Excel | |||
| Copying cell contents to add to existing contents in another cell | Excel Programming | |||
Hybrid Mode
