Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
terry b. - 22 Oct 2006 01:18 GMT
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 - 22 Oct 2006 01:26 GMT
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....
[quoted text clipped - 15 lines]
> riprap
> evans, co [=o
terry b. - 22 Oct 2006 02:14 GMT
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
[quoted text clipped - 26 lines]
> > riprap
> > evans, co [=o
Pete_UK - 22 Oct 2006 15:53 GMT
Thanks for feeding back.

Pete

> Hello, Pete:
>   Well, I guess if you look up "stupid question" in the dictionary,
[quoted text clipped - 34 lines]
> > > riprap
> > > evans, co [=o

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.