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

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
--
Esther

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

Hi Esther

Just right click on the column heading where you want to insertInsert

Imagine you have cells A2:C2 merged, and you want there to be 4 columns
under that merged section.
Right click DInsert 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"FormatCellsAlignmentHorizontalCent er across selection.
Once again, inserting extra columns will behave as previously described.
--
Regards
Roger Govier

"Esther" wrote in message
...
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
--
Esther

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

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

Scooterlady

"Esther" wrote:

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
--
Esther

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

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"

"

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

What is the message when you do insertrows.
What version of Excel?

--


Regards,


Peo Sjoblom

"Scooterlady" wrote in message
...

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"

"

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

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


On Fri, 1 Aug 2008 09:57:02 -0700, Scooterlady
wrote:

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

Scooterlady

"Esther" wrote:

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
--
Esther