Menu
Normally when you type enough characters in cell A1, they display over the cell(s) to the right (B1, C1, etc.). I had a workbook where this was the case, then suddenly I noticed that the text in A1 only displayed in A1 and no longer displayed over the cells to the right. Cells B1, C1, etc. were completely empty/deleted/cleared. I could find no cell formatting like wrap text or otherwise that would cause this.
Is there a setting, global or otherwise, that would cause or allow this behavior?
Merge cells sort of makes the text appear as desired, but it doesn't make sense that this is the best fix. The cells were never merged before, and don't need to be merged in a new workbook for the "normal" behavior to be seen.
272
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).
Select the cells you wish to stop from spilling over. On the Home tab, in the Cells group, click Format > Row Height. The Row Height box will appear showing the current height of the selected cells. Click OK without changing anything just to confirm your present row height.
Note: If all wrapped text is not visible, it might be because the row is set to a specific height. To enable the row to adjust automatically and show all wrapped text, on the Format menu, point to Row, and then click AutoFit.
All you can do is, right click that cell, choose Format cell, then in the text section, set text to wrap and set the cell height to automatic . . . Was this reply helpful?
I found the culprit setting: Show Formulas (Formulas ribbon tab, Formula Auditing). The shortcut for this command is Ctrl+`. My backward single quote is right above my tab key, so I bet when I was Ctrl+tabbing between multiple spreadsheets I accidentally enabled Show Formulas. I was in the data-entry area of my workbook, so it took me a while to notice formulas were displayed instead of results.
165
mark affected cell(s), press ctrl-1, second tab and you will find a checkbox for text wrap.
22
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
