New
#11
Does any of your answer solve the problem of text limit in a cell?Here we go! ding dong! Actually, this is an interesting discussion.
The alternative method to the first one I mentioned that does involve merging cells and does not involve adjusting the size of the column holding the cell you typed text into beforehand has its own serious limitations, and can lead to more trouble than it's worth if more text is added to the cell range than it has the capacity to hold.
Whilst you are able to select a range of adjacent cells both to the right and below the extended right cell containing the text and hit Merge cells to create the expanded range with the text nicely formatted inside that newly defined range, it only works if that pre-selected cell range has enough text capacity. Otherwise, the overflow is invisible.
If you then try to correct this problem by selecting other adjacent cells to include in the original merge cells group selected to correct this problem, you cannot only select just enough extra cells to just hold the overflow text. Instead, it forces you to accept the only available option of simply duplicating the cell group to the same dimensions as the original merged cell group you created, and then simply copies the original text inside the duplicate, with no extra white space, so is useless. It also doubles the entire original merged group dimensions undesirably.
You can then merge the two groups but, if you do, you create a new cell group range that is 4 x the dimensions of the original in which ever direction you selected, either right or beneath. Also utterly useless.
The other way of dealing with the overflow using this Merge cells method is to change the column and/or width dimensions controlling the new cell group's dimensions to accomodate the overflow. However, you then obviate the advantage gained by using this method to avoid adjacent column and/or line dimensions being increased.
So this alternative method merge cells method has both pros and cons. The very nice pro is that no adjacent column or line sizes are altered and remain at default cell dimensions. Very nice indeed. But the con is that you have to know the exact dimensions of the cell range box beforehand. It is not adjustable afterwards in any desirable fashion. And you still end up having to alter adjacent column and line dimensions, thus obviating choosing this method in the first place.
The first method I mentioned a few posts back just using Wrap text also has pros and cons. The pro is you end up with an auto-sized text area determined in width by the expanded column dimensions you first set. The con is that the entire column and width of the expanded text cell is widened causing its own difficulties with layout for the rest of the sheet.
Personally, I prefer the Merge method, but you have to know how many cells to select for the merge group to accomodate all of the text with no overflow or too much white space beforehand. Otherwise, the advantage gained using this method by virtue of not affecting the dimensions of any whole lines or columns is significant, without needing to use a text box that has its own pros and cons of a different nature.
Best wishes,
Christophe
- - - Updated - - -
You are most welcome.
I am using Office-365 and don't have stand-alone 2019 version installed (very nice btw), so cannot replicate the methods I have listed for that reason. However, I seem to remember, from when I did use 2019 and even earlier versions, that there is no difference with respect to merge and wrap functions for any 2000 + version. Could be wrong but...
Christophe
Are you able to copy and paste all the text in this link to your excel single cell? 1996 California Proposition 218 - Wikipedia