Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid cell overlapping?
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid cell overlapping?
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: 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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid cell overlapping?
Hi excelent,
I can't find 'Fill' in Vertical dropdown... :-( Thanks. "excelent" wrote: 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: 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... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid cell overlapping?
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 On Thu, 19 Jul 2007 08:22:05 -0700, Tim wrote: 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... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid cell overlapping?
Hi,
The problem is i can't disable the autofit anymore... Anyway thanks, I have now the idea.. "Gord Dibben" wrote: 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 On Thu, 19 Jul 2007 08:22:05 -0700, Tim wrote: 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... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid cell overlapping?
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 On Thu, 19 Jul 2007 12:54:01 -0700, Tim wrote: Hi, The problem is i can't disable the autofit anymore... Anyway thanks, I have now the idea.. "Gord Dibben" wrote: 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 On Thu, 19 Jul 2007 08:22:05 -0700, Tim wrote: 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overlapping Arrays? | Excel Discussion (Misc queries) | |||
Overlapping Charts | Charts and Charting in Excel | |||
overlapping error bars | Charts and Charting in Excel | |||
Overlapping Pie Charts | Charts and Charting in Excel | |||
How to avoid black shade fill on the from cell,when drag-and-drop | New Users to Excel |