cell text not displaying into next blank cell

[Guest]

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

 

[Guest]

I would think there must be a space or more in what looks like blank cells.
Try highlighting the blank cells and deleting them with the delete key on the
keyboard. This should get rid of any spaces and let the text flow from A
into B and C

 

[Guest]

To do this for one cell only double click on the line between A & B at the
top of the page.

If more than one cell then the easiet way is to select the row or rows and
then select Format, Column, Autofit selection.

 

[Guest]

This adjusts the cell widths, but I think Matthew's issue is the same that I
have. In some worksheets, text carries over into adjoining blank cells, but
in other worksheets it does not. Even after clearing/deleting the adjacent
cell to make sure that there wasn't a space or other invisible object there,
the text still won't display. You can merge the cells to have the text
display completely or do as JMC suggests and increase the width of the cells,
but I would prefer to keep the cell width smaller and have the text display
across the blank cells, as it does with most Excel sheets.

To do this for one cell only double click on the line between A & B at the
top of the page.

If more than one cell then the easiet way is to select the row or rows and
then select Format, Column, Autofit selection.

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