Excel 2021 cell limit

Page 2 of 4 FirstFirst 1234 LastLast

  1. Posts : 82
    Windows 10 Home 64 bit x64
    Thread Starter
       #11

    CMArbres said:
    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
    Does any of your answer solve the problem of text limit in a cell?

    Are you able to copy and paste all the text in this link to your excel single cell? 1996 California Proposition 218 - Wikipedia
      My Computer

  2. CMArbres's Avatar
    Posts : 135
    Windows 10 Home Version: 21H1 (OS Build 19043,1387)
       #12

    comcom said:
    Does any of your answer solve the problem of text limit in a cell?

    Are you able to copy and paste all the text in this link to your excel single cell? 1996 California Proposition 218 - Wikipedia
    In short, yes. and no. How about you? Have any of your questions been genuine? Don't worry, I can take a joke.
    Last edited by CMArbres; 05 Dec 2021 at 07:37. Reason: Altered second yes to no
      My Computers

  3. sygnus21's Avatar
    Posts : 5,759
    Win 10 Pro (x64) 21H1 (19043.1023
       #13

    CMArbres said:

    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.
    I think you don't understand what I'm saying. Apparently, you've never done a cell drag cause if you did, you'd know how simple and easy it is to quickly resize cells. This would only be new to those who've not used Excel a lot.

    Here Cell A1 has been manually drug across and down to make room for this entire post. It was also formatted to display the text as shown
    Excel 2021 cell limit-screenshot-2021-12-04-113642.jpg

    Seems like you're trying to justify your lack of understanding here by falsely claiming something not true.

    Moving on.
      My Computers

  4. CMArbres's Avatar
    Posts : 135
    Windows 10 Home Version: 21H1 (OS Build 19043,1387)
       #14

    sygnus21 said:
    Moving on.
    What a great idea!
      My Computers

  5. sygnus21's Avatar
    Posts : 5,759
    Win 10 Pro (x64) 21H1 (19043.1023
       #15

    Yes, especially since I'm arguing with someone who doesn't know what they're talking about as proven...



    Put the mouse between two cells (A & B for length, 1 & 2 for height) and when the mouse turns into a cross, and you can drag till your heart is content. This is what I said in post #4 when I said drag

    Later
      My Computers

  6. Dude's Avatar
    Posts : 15,987
    Windows 11 Pro X64
       #16

    Spot on @sygnus21
      My Computers

  7. sygnus21's Avatar
    Posts : 5,759
    Win 10 Pro (x64) 21H1 (19043.1023
       #17

    Thanks Dude
      My Computers


  8. Posts : 1,316
    Windows 10 Pro 64-bit
       #18

    Bree said:
    Limits in Excel seem to be the same for all versions from Office 2007 onwards.

    https://support.microsoft.com/en-us/...Newer_versions
    I would work within the limits of Bree's information

    However, I took a look at the recorded characters in Wikipedia's 1996 California Proposition 218.
    --- I copied & pasted most of Wikipedia's 1996 California Proposition 218 up to References into a Word 2016 document to determine the number of characters.

    Excel 2021 cell limit-character-count.jpg

    Result: with spaces) 167,336.

    Post #11 "But the con is that you have to know the exact dimensions of the cell range box beforehand."
    --- Repeat your original procedure into one cell & then calculate the number of characters including with spaces.
    --- Then determine the resize & merging procedures recommended to accommodate the full number of characters.
      My Computer

  9. CMArbres's Avatar
    Posts : 135
    Windows 10 Home Version: 21H1 (OS Build 19043,1387)
       #19

    MeAndMyComputer said:
    I would work within the limits of Bree's information
    Amen to that!

    Post #11 "But the con is that you have to know the exact dimensions of the cell range box beforehand."
    And when you do, you get a result that looks like this, with all adjacent cells still usable, and still retaining their original default sizes.
    Excel 2021 cell limit-cell-merge-1.png

    I appreciate this is not in allignment with the OP's question. However, it is a valid demonstration of the value of the method of using the cell merge function to much better overall advantage than using just a single cell for large text input.

    Whilst it is certainly intellectually interesting to test the capacity of a single single cell for holding very large quantities of text, another consideration is the impact upon available memory. It may be the case that by entering the maximum possible quantity allowed by Excel, the sheet becomes impossible to even load, let alone view, without locking up. I don't know the answer to that though my machine did not like having to load the Wiki article text linked to in this thread. To my mind, it seems only of intellectual interest, but of no practical value.

    Meanwhile, as I have apparently been deemed to be an untruthful idiot by a couple of real charmers in this shockingly toxic thread, I shall stop designing any more Decision Support Systems in Excel and, instead, study how to resize cells by dragging them from the + symbol in the lower right-hand corner. If after a year or two of practicing that I feel competent enough to do it proficiently, I'll post back here with the evidence.

    I have only tried to help anyway, quite genuinely. I must say that I have otherwise found this community to be very welcoming and friendly.

    Christophe
    Last edited by CMArbres; 04 Dec 2021 at 19:11.
      My Computers


  10. Posts : 1,316
    Windows 10 Pro 64-bit
       #20

    @comcom opening post #1 "Is Excel 2021 cell character limit more than Excel 2019 cell character limit?
    --- For an Excel single cell character limit, it doesn't matter whether you are using Excel 2021 or 2019.

    Excel specifications and limits
    Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
    https://support.microsoft.com/en-us/...Newer_versions

    Newer versions
    Total number of characters that a cell can contain 32,767 characters.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 12:45.
Find Us




Windows 10 Forums