View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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