Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
WITHOUT MERGING THE CELLS:- I want to :
VERTICALLY, over the space of lets say about 20 cells, (I will Color that Area of 20 Cellsin one color) I want to write a long sentence (in One Cell) and have THAT text over lap all the other 19 cells. NO TEXT will be written in ANY of those other 19 Cells. Is that Possible? Please help! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
No. Although text can overlap other empty cells on the same row (i.e.
horizontally), you can not do this vertically. Hope this helps. Pete On Dec 8, 8:59*am, Muffi Zainu wrote: WITHOUT MERGING THE CELLS:- I want to : VERTICALLY, over the space of lets say about 20 cells, (I will Color that Area of 20 Cellsin one color) I want to write a long sentence (in One Cell) and have THAT text over lap all the other 19 cells. NO TEXT will be written in ANY of those other 19 Cells. Is that Possible? Please help! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Muffi
In the case where the cell containing the text is the left-most cell: With the cell format 'Text Wrap' option disabled -and- If all of the adjoining cells are all empty -and- the cell containing the text is left justified, the content of the first cell should spill out over the adjoining cells. If there is any thing at all in any of the adjoining cells, the text will cease to be displayed when it reaches the left side of the cell that contains the entry. Don't think there is a way to override this, but you could look into using a Text Box. "Muffi Zainu" wrote: WITHOUT MERGING THE CELLS:- I want to : VERTICALLY, over the space of lets say about 20 cells, (I will Color that Area of 20 Cellsin one color) I want to write a long sentence (in One Cell) and have THAT text over lap all the other 19 cells. NO TEXT will be written in ANY of those other 19 Cells. Is that Possible? Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to merge cells vertically - and keep all data | Excel Discussion (Misc queries) | |||
Text in cells is cut off vertically when i Print | Excel Discussion (Misc queries) | |||
How do I number cells vertically in succession? Example: (1 2 3) | Excel Worksheet Functions | |||
How do I link horizontal cells vertically? | Excel Discussion (Misc queries) | |||
Move cells vertically to horizontally | Excel Discussion (Misc queries) |