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

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

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

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

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

To split a cell in half in Microsoft Excel, you can use the "Merge & Center" feature. Here are the steps:

1. Select the cell that you want to split in half.
2. Click on the "Merge & Center" button in the "Alignment" group on the "Home" tab.
3. This will merge the selected cell with the cell to its right, creating one large cell.
4. Type the text you want to appear in the left half of the cell.
5. Type a forward slash (/) to separate the two halves of the cell.
6. Type the text you want to appear in the right half of the cell.

For example, if you want to check "Yes" or "No" in the same cell, you could type "Yes/No" after merging and centering the cell. This will create two halves of the cell, with "Yes" on the left and "No" on the right. You can then select the appropriate half of the cell to enter your data.