Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a cell
I want to put in text and split in half in a cell like
values actions but with a line seperating them in two parts, I was able to use the borader but the effect is not perfect. Does anyone has better suggestion? Unfortunately, I can not paste the screen to this message. thanks, Ray |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a cell
Press Alt+enter where you want a line break
Tyro "Ray" wrote in message ... I want to put in text and split in half in a cell like values actions but with a line seperating them in two parts, I was able to use the borader but the effect is not perfect. Does anyone has better suggestion? Unfortunately, I can not paste the screen to this message. thanks, Ray |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a cell
No way to split a cell.
Diagonal Border or a line from the Drawing Toolbar and some manipulation will have to to do the trick. Alt + Enter to split the text into two lines in the cell then add a drawing line across horizontally. Gord Dibben MS Excel MVP On Mon, 7 Jan 2008 16:54:07 -0800, Ray wrote: I want to put in text and split in half in a cell like values actions but with a line seperating them in two parts, I was able to use the borader but the effect is not perfect. Does anyone has better suggestion? Unfortunately, I can not paste the screen to this message. thanks, Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |