| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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" " |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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" " |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 - Split Contents of Cell Across Multiple Cells | Excel Discussion (Misc queries) | |||
| Can I split a excel cell w/out adding a column? | Excel Discussion (Misc queries) | |||
| how do you split a cell within the same column? | Excel Worksheet Functions | |||
| how can I split a single cell diagonally in Excel 2000 | Excel Discussion (Misc queries) | |||
| In Excel 2000, how do I add a vertical scroll bar to a split scre. | Excel Discussion (Misc queries) | |||
Linear Mode
