For an example:

Normally I can open a new workbook, I can type enough characters in cell A1,
that when I am typing it clearly goes over cell B1 and C1 (I typed "the quick
brown fox jumped"). And when done typing, the set of characters displays
over Cells B1 and C1.
However, when I type anything into B1, the text in A1 only displays the text
that is viewable in A1.


My issue is that in one of my spreadsheets, I have a similar situation where
I want the text to be displayed in full, since there is nothing in the
adjacent cells -- but, it doesn't. anywhere on that sheet it only allows
for a display in one cell.
[it does allow for 'wrap text' to work, but that's not what I'm looking to
do.]

Is there a setting, global or otherwise, that I need to correct to allow for
cells to display their content, as long as there is no conflicts?

I appreciate any time someone has that can help.

Cheers,

Matt