S
skyyak
I have seen worksheets in which some colums have two rows. How do I d
this? Thanks
this? Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
There are two lines within the cell?
Try hitting alt-enter where you want the line to split.
(format|cells|alignment tab|wrap text will have to be checked if you see a
little square box)
And as a formula:
="This is a" & char(10) & "of two lines in a cell."
Try hitting alt-enter where you want the line to split.
(format|cells|alignment tab|wrap text will have to be checked if you see a
little square box)
And as a formula:
="This is a" & char(10) & "of two lines in a cell."
S
skyyak
If I click on two cells and merge them, that is doing the opposite o
what I want- I basically want to put two cells in one
what I want- I basically want to put two cells in one
F
Frank Kabel
Hi
another idea: Format - Cells - merge cells
to create merged cells
another idea: Format - Cells - merge cells
to create merged cells
A
AlfD
Hi!
Think carefully about the advice you have been given.
The reason no-one is jumping in to answer the question as you pose i
is because it can't be done. What can be done is to create th
appearance of having put 2 cells into one.
I think you should try it: Select cells A1 and B1.
Format > Cells > Alignment and click the box for merge cells.
Now go to Borders and put a border round this merged range.
Copy A1 & B1
Paste special > formats onto A3:B40 (missing A2)
Go now to A2 and B2 and Format >Cells > Borders: put some lines roun
them.
The result should look as though 2 cells (A2 and B2) have been inserte
into 1 cell of the A/B merged selections.
But it will only look like it: it won't behave like it when addressin
cells.
In fact, most people with experience don't like merge because it ca
seriously hinder worksheet operatons. So I'm not recommending it
merely explaining it.
Al
Think carefully about the advice you have been given.
The reason no-one is jumping in to answer the question as you pose i
is because it can't be done. What can be done is to create th
appearance of having put 2 cells into one.
I think you should try it: Select cells A1 and B1.
Format > Cells > Alignment and click the box for merge cells.
Now go to Borders and put a border round this merged range.
Copy A1 & B1
Paste special > formats onto A3:B40 (missing A2)
Go now to A2 and B2 and Format >Cells > Borders: put some lines roun
them.
The result should look as though 2 cells (A2 and B2) have been inserte
into 1 cell of the A/B merged selections.
But it will only look like it: it won't behave like it when addressin
cells.
In fact, most people with experience don't like merge because it ca
seriously hinder worksheet operatons. So I'm not recommending it
merely explaining it.
Al
D
Dave Peterson
I don't think I understand, but if you meant you want a third cell that combines
two other cells:
=a1&b1
or
=a1&" "&b1
two other cells:
=a1&b1
or
=a1&" "&b1