Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell properties
I sometimes use merged cells to display concatenated info. After about 1100
characters, the cells won't display the remaining text no matter how heigh the rows or wide the colums. Question #1 Is there a way to set the cell limits for how many characters can be displayes? Question #2 In the above senario the merged cells that contain the concatenate instructions will not automatically adjust the row heighth for the content even thought the wrap text function is turned on. Is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell properties
A cell will accept 32767 characters but by default Excel will show only 1024 of
these characters in the cell.......you see them all in the formula bar. Merging several cells into one does not change this. You still have only one cell. To see more chars in a cell, you must use an Alt + Enter linefeed every 80-100 characters or a smaller font size. Merged cells will wrap text but not autofit. You need VBA event code to make that happen. My advice..........don't use merged cells. They cause no end of problems with such as above and other operations like cut, copy, paste, sort, filter. If you want the code for autofit see this thread......... http://tinyurl.com/2oehen Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 15:51:00 -0700, mike wrote: I sometimes use merged cells to display concatenated info. After about 1100 characters, the cells won't display the remaining text no matter how heigh the rows or wide the colums. Question #1 Is there a way to set the cell limits for how many characters can be displayes? Question #2 In the above senario the merged cells that contain the concatenate instructions will not automatically adjust the row heighth for the content even thought the wrap text function is turned on. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell properties changes | Excel Discussion (Misc queries) | |||
cell properties. hours? | Excel Discussion (Misc queries) | |||
Excel cell properties | Excel Worksheet Functions | |||
Cell changing it's properties | New Users to Excel | |||
Mystery Cell Properties | Excel Worksheet Functions |