Columns in excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
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.
 
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
 
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...
 
Discovered that I can merge cells to give the appearance of independent
column widths. That'll do fine.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Excel Help to copy information from one row at a time to another sheet 1
Automatic rows creation with various permutation of column values 2
using the =page! feature to transpose a row to column 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
need quick help averaging multiple rows 3
Drag Down Formula Incorrect 3
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0

Back
Top