excel 2000-split a cell or a column or a row without transferring

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Esther - 15 May 2008 16:59 GMT

Top row is all merged. Underneath is a row consisiting of several groups of
merged cells, each of which is acting as a heading for the columns
underneath. How to insert more blank columns underneath each heading? Thanks

Signature

Esther

Reply to this Message

Roger Govier - 16 May 2008 09:49 GMT

Hi Esther

Just right click on the column heading where you want to insert>Insert

Imagine you have cells A2:C2 merged, and you want there to be 4 columns
under that merged section.
Right click D>Insert and now the merged cells will be A2:D2

As a generality, Merged cells should be avoided as they can cause all sorts
of other problems when trying to carry out other tasks.
You can achieve the same appearance, by selecting the range of cells you
wish to "merge">Format>Cells>Alignment>Horizontal>Center across selection.
Once again, inserting extra columns will behave as previously described.

Signature

Regards
Roger Govier

> Top row is all merged. Underneath is a row consisiting of several groups
> of
> merged cells, each of which is acting as a heading for the columns
> underneath. How to insert more blank columns underneath each heading?
> Thanks

Reply to this Message

Scooterlady - 01 Aug 2008 17:57 GMT

I am trying to merge cells. I only want to insert extra rows.

Scooterlady

> Top row is all merged. Underneath is a row consisiting of several groups of
> merged cells, each of which is acting as a heading for the columns
> underneath. How to insert more blank columns underneath each heading? Thanks

Reply to this Message

Scooterlady - 01 Aug 2008 18:07 GMT

I do not want to merge cells. I want to insert more rows. I have clicked on
insert rows and my computer is telling me a do not have this function.

"Scooterlady"

> "

Reply to this Message

Peo Sjoblom - 01 Aug 2008 18:13 GMT

What is the message when you do insert>rows.
What version of Excel?

Signature

Regards,

Peo Sjoblom

> I do not want to merge cells. I want to insert more rows. I have clicked
> on
[quoted text clipped - 3 lines]
>>
>> "

Reply to this Message

Gord Dibben - 01 Aug 2008 20:31 GMT

You can insert rows above or below merged cells but not in the middle of
merged cells.

If you have no extremely compelling reason to merge cells..........please
stay away from that feature.

They cause no end of problems.

Gord Dibben MS Excel MVP

>I am trying to merge cells. I only want to insert extra rows.
>
[quoted text clipped - 3 lines]
>> merged cells, each of which is acting as a heading for the columns
>> underneath. How to insert more blank columns underneath each heading? Thanks

Reply to this Message