How do i split a cell in the middle

[Seb]

Im trying to design an invoice, nearly there but i just need to split a cell
into two, so i can have the from and send to right next to each other. Its
on the same column as item details so i cant make it smaller to do the job.
That might be hard to understand i know but i'll do a little example of what
i want:-

|invoice|

|send to:| from:|
|address| address|

Kinda like that, but how i have it its like this:

|invoice|

|send to:| <---- as i stated before the item details row it big so i cant
resize it to fit my address right next to the customers
|address|

|item | qty | |total|

I know i can resign it but i like it there way it is, so i need to find a
way of spliting that one cell right in the middle without spliting the whole
column, is this possible?

 

[lsu-i-like]

in word you can split cells, i dont think you can in excel. what i d
in that situation is add a column and merge all the cells that you don
want split in two

 

[JulieD]

Hi Seb

sorry, you can't split just a cell.

Cheers
JulieD

 

[Guest]

Seb,

I'm not sure if this will get you any closer but, while you cannot split
cells, you CAN merge cells. So you could try something like this. Place your
data in a configuration as follows:

A1: "Invoice"

A3: "Send To:" B3: Joe Smith
A4: "Address:" B4: 123 Fake Street

A6: "Item" D6: "qty" E6: "total"
A7 Left-handed refractors D7: 42 E7: $420

Now select Cells A6:C6 and choose Format->Cells. On the Alignment tab, click
on the "Merge Cells" box and OK. Repeat this for each row from A7 down, for
as far as your item list will go (or just do row 7 and copy it down.

Now you can resize column A such that the name/address labels are next to
the data.

Of course, the merge-cells portion of this is actually unnessecary, but
makes data entry slightly easier.

HTH,

Ryan

 

[Seb]

Ahh, ok. Cheers

Hi Seb

sorry, you can't split just a cell.

Cheers
JulieD