If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do you split a cell in half? (/)
I am trying to split a cell so I can enter data in both halfs of the cell. An
example would be to check a yes/no |
#2
|
|||
|
|||
how do you split a cell in half? (/)
Use two cells.
You could screw around with adding a diagonal border and some extra spaces and an alt-enter, but your life will be miserable when you try to parse that to find out what's in the cell. Tommy wrote: I am trying to split a cell so I can enter data in both halfs of the cell. An example would be to check a yes/no -- Dave Peterson |
#3
|
|||
|
|||
how do you split a cell in half? (/)
You cannot split a cell in half.
An Excel sheet has quite a few cells. Use them. You could get the appearance of a split cell using a diagonal border, top alignment of text, a few Alt + Enters and some spaces to move the no to bottom right. But you could do nothing with the cell other than see the text. Gord Dibben MS Excel MVP On Tue, 22 Sep 2009 16:02:14 -0700, Tommy wrote: I am trying to split a cell so I can enter data in both halfs of the cell. An example would be to check a yes/no |
#4
|
|||
|
|||
how do you split a cell in half? (/)
Or you could use data validation with a list for yes, no or a checkbox from
the control menu -- Don Guillett Microsoft MVP Excel SalesAid Software "Tommy" wrote in message ... I am trying to split a cell so I can enter data in both halfs of the cell. An example would be to check a yes/no |
#5
|
|||
|
|||
how do you split a cell in half? (/)
Hi Tommy,
If you want to show a Yes/No checkbox, there is a little trick that I use. 1) Format a cell as Wingdings font 2) Add borders around the cell 3) Apply the custom format "ü";;"û" 4) Use a data validation list to limit the cell values to 1 and 0 (or just enter 1 for Yes, 0 for No). The custom format shows a tick for all positive values, nothing for negative values, and a cross for zeroes. Limiting input to 1 and 0 makes it easy to use the cell in True/False formulas. If using Excel 2007 you can make this look even better by using conditional formatting and the 3 symbol icon set. In that case just use the custom format ;; (does not show numbers in the cell), and make sure you limit the input to 0 and 1. Ed Ferrero www.edferrero.com |
Thread Tools | |
Display Modes | |
|
|