Splitting a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jessee - 03 May 2006 14:35 GMT

I have a spreadsheet with column headings. Several of the columns need
to be split. How do I do this without splitting the heading?

Signature

Jessee

Reply to this Message

Niek Otten - 03 May 2006 16:37 GMT

Hi Jessee,

Please explain what "splitting a column" means.
Can you give an example?

Signature

Kind regards,

Niek Otten

| I have a spreadsheet with column headings. Several of the columns need
| to be split. How do I do this without splitting the heading?

Reply to this Message

Jessee - 03 May 2006 17:00 GMT

Hi Niek,

I have a column named "Product". Beneath it I would like the product
column split into two columns, one named "Qty" and one named "Amount".
Hope this helps!

Thanks, Jessee

Signature

Jessee

Reply to this Message

Niek Otten - 03 May 2006 17:18 GMT

For the Product heading, look at

Format>Cells>Alignment tab, check Merge Cells.

Signature

Kind regards,

Niek Otten

| Hi Niek,
|
[quoted text clipped - 3 lines]
|
| Thanks, Jessee

Reply to this Message

Jessee - 03 May 2006 18:04 GMT

The word "Product" should be in a cell by itself. "Qty" and "Amount"
should each be in their own columns in the next row (with a line to
separate each column) directly beneath the word "Product".

I didn't seem to achieve this desired result.

Thanks again.

Signature

Jessee

Reply to this Message

BruceP - 03 May 2006 18:10 GMT

If "Product" is in cell A1, and your product lists start in cells A1 and
B2, the suggestion above should work. Hilite cells A1 and B1, and click
the Merge & Center button (or do it through the cell formatting menus).
"Products" will be perfectly centered above the A and B columns.

Signature

BruceP

Reply to this Message

Jessee - 03 May 2006 22:12 GMT

Got it. Thank you both for your help!

Signature

Jessee

Reply to this Message