Columns in excel 2003

J

Jackie D

Hi

Can anyone tell me if it is possible to create extra columns in excel that
are independent from the row above. e.g. can I have four columns in one row
and eight in the one below?
 
B

Bob Phillips

No, you can merge cells (Format>Cells>alignment), but not specifically what
you ask.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
H

Harlan Grove

Jackie D wrote...
Can anyone tell me if it is possible to create extra columns in excel that
are independent from the row above. e.g. can I have four columns in one row
and eight in the one below?
Click to expand...

No.
 
R

Roger Govier

Hi Jackie

You can't.
You can merge cells, to have 4 blocks of 2 merged cells in row 1, which
would have the appearance of being what you want.
Highlight 2 cells, Format>Cells>Alignment and click Merge.

Beware of merged cells when sorting or in some other instances where they do
not behave as you might expect.

Alternatively mark 2 cells and Format>Cells>Alignment>Horizontal and from
dropdown choose centre across selection. Place a border around each pair of
cells treated in this way, and place borders around individual cells on the
row below.

Regards

Roger Govier
 
J

Jackie D

Right. Thanks
--


Many thanks
JD


Bob Phillips said:
No, you can merge cells (Format>Cells>alignment), but not specifically what
you ask.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
J

Jackie D

Discovered that I can merge cells to give the appearance of independent
column widths. That'll do fine.
 
J

Jackie D

Thanks for the help Roger.
--


Many thanks
JD


Roger Govier said:
Hi Jackie

You can't.
You can merge cells, to have 4 blocks of 2 merged cells in row 1, which
would have the appearance of being what you want.
Highlight 2 cells, Format>Cells>Alignment and click Merge.

Beware of merged cells when sorting or in some other instances where they do
not behave as you might expect.

Alternatively mark 2 cells and Format>Cells>Alignment>Horizontal and from
dropdown choose centre across selection. Place a border around each pair of
cells treated in this way, and place borders around individual cells on the
row below.

Regards

Roger Govier
Click to expand...
 
Top