How to avoid cell overlapping?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is there anyone knows how to avoid overlapping? Here's I want to do, I don't
like my data, if it's too long, jump over the next empty cell... I just want
to hide the rest of text. Nope, I don't want to wrap it too. I'm thinking of,
if the size of the cell is 50x12.75, let it be. No wrapping and no
overlapping... Is that possible?

Because the tendency of overlapping is, texts that jumps to a particular
empty cell will be mistaken as data of that particular column...
 
Well ill try explain in english :-)

Select cell/range
Rightclick and select "Format cells"
Select Justifye-Tab - i think the name is -(second tab from left)
Select Fill out in Vertical-dropdown
OK



"Tim" skrev:
 
Wrap Text will do the job and leave the cell the same size as long as you don't
set the row to "Autofit".


Gord Dibben MS Excel MVP
 
Hi,

The problem is i can't disable the autofit anymore... Anyway thanks, I have
now the idea..
 
Yes, the Horizontal "Fill" works fine.

Just curious. Why can't you disable autofit?

Just manually re-size the row and autofit is disabled.


Gord
 
Back
Top