Cell contents-display extends into next cell (???)

[terry b.]

Hello, all [=D
What's probably a very simple format-setting has got me baffled....
I was copying some columns & then pasting them (paste special >
values) into a fresh worksheet, in order to get rid of all the tick
marks at the beginning of the cells. The tick marks are gone. But now,
for some reason I can't figure out, in the column's cells on the new
sheet--in a column formatted as General-- when there's too much text to
fit into their own column, it's extending into the neighboring cell.
For example, if Column A is 75 pixels wide, and I happen to have 85
pixels-worth of text in cell A2, the extra 10 pixels-width of material
is being plainly-display in cell B2. What up?
If I enter data into B2, the unwanted text disappears and the new
data displays fine. But for all the cells in Column B that are empty,
if the material in Col A is too wide it's 'intruding' into the next
column, even tho there haven't been any cells merged.
Can anyone help with this?
TIA
riprap
evans, co [=o

 

[Pete_UK]

That is how Excel works - if the text is too wide to fit into the
column width and the next cell is empty then the text will show in the
next column. You can adjust the column widths - double click the
vertical bar between column A and column B to auto-adjust. Or, you
could make the cells wrap - with column A highlighted, click Format |
Cells | Alignment tab and check Wrap Text.

Hope this helps.

Pete

 

[terry b.]

Hello, Pete:
Well, I guess if you look up "stupid question" in the dictionary,
there'd be a copy of my original post in it, right? I guess it's been
so long since I used cells to hold 80-90 pixels-worth of text, that I
just didn't remember.
I appreciate your time & patience!
riprap aka "doo-duh-doooh!" (w/ apologies to Carlos Mencia)

That is how Excel works - if the text is too wide to fit into the
column width and the next cell is empty then the text will show in the
next column. You can adjust the column widths - double click the
vertical bar between column A and column B to auto-adjust. Or, you
could make the cells wrap - with column A highlighted, click Format |
Cells | Alignment tab and check Wrap Text.

Hope this helps.

Pete

Hello, all [=D
What's probably a very simple format-setting has got me baffled....
I was copying some columns & then pasting them (paste special >
values) into a fresh worksheet, in order to get rid of all the tick
marks at the beginning of the cells. The tick marks are gone. But now,
for some reason I can't figure out, in the column's cells on the new
sheet--in a column formatted as General-- when there's too much text to
fit into their own column, it's extending into the neighboring cell.
For example, if Column A is 75 pixels wide, and I happen to have 85
pixels-worth of text in cell A2, the extra 10 pixels-width of material
is being plainly-display in cell B2. What up?
If I enter data into B2, the unwanted text disappears and the new
data displays fine. But for all the cells in Column B that are empty,
if the material in Col A is too wide it's 'intruding' into the next
column, even tho there haven't been any cells merged.
Can anyone help with this?
TIA
riprap
evans, co [=o

 

[Pete_UK]

Thanks for feeding back.

Pete

Hello, Pete:
Well, I guess if you look up "stupid question" in the dictionary,
there'd be a copy of my original post in it, right? I guess it's been
so long since I used cells to hold 80-90 pixels-worth of text, that I
just didn't remember.
I appreciate your time & patience!
riprap aka "doo-duh-doooh!" (w/ apologies to Carlos Mencia)

That is how Excel works - if the text is too wide to fit into the
column width and the next cell is empty then the text will show in the
next column. You can adjust the column widths - double click the
vertical bar between column A and column B to auto-adjust. Or, you
could make the cells wrap - with column A highlighted, click Format |
Cells | Alignment tab and check Wrap Text.

Hope this helps.

Pete

Hello, all [=D
What's probably a very simple format-setting has got me baffled....
I was copying some columns & then pasting them (paste special >
values) into a fresh worksheet, in order to get rid of all the tick
marks at the beginning of the cells. The tick marks are gone. But now,
for some reason I can't figure out, in the column's cells on the new
sheet--in a column formatted as General-- when there's too much text to
fit into their own column, it's extending into the neighboring cell.
For example, if Column A is 75 pixels wide, and I happen to have 85
pixels-worth of text in cell A2, the extra 10 pixels-width of material
is being plainly-display in cell B2. What up?
If I enter data into B2, the unwanted text disappears and the new
data displays fine. But for all the cells in Column B that are empty,
if the material in Col A is too wide it's 'intruding' into the next
column, even tho there haven't been any cells merged.
Can anyone help with this?
TIA
riprap
evans, co [=o