| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Cell Merge
I have a spread sheet with a few merge cells that I can not unmerge. I've
used the on-line help but was still unable to find the right operation to unmerge. While on-line I did see this note Note If the Merge and Center button is unavailable, the selected cell may be in editing mode. To cancel editing mode, press ENTER. But it still did not allow the cells to be split. The sheet is not lock protected, any advise? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Cell Merge
Hi,
try selecting the whole sheet and then press the merge and center button "HM" wrote: I have a spread sheet with a few merge cells that I can not unmerge. I've used the on-line help but was still unable to find the right operation to unmerge. While on-line I did see this note Note If the Merge and Center button is unavailable, the selected cell may be in editing mode. To cancel editing mode, press ENTER. But it still did not allow the cells to be split. The sheet is not lock protected, any advise? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Cell Merge
Eduardo
The tip did not work, the merge / center button did not make itself available. "Eduardo" wrote: Hi, try selecting the whole sheet and then press the merge and center button "HM" wrote: I have a spread sheet with a few merge cells that I can not unmerge. I've used the on-line help but was still unable to find the right operation to unmerge. While on-line I did see this note Note If the Merge and Center button is unavailable, the selected cell may be in editing mode. To cancel editing mode, press ENTER. But it still did not allow the cells to be split. The sheet is not lock protected, any advise? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Cell Merge
"HM" wrote:
The tip did not work, the merge / center button did not make itself available. Maybe FormatCells route would do it for you? Select the entire sheet, then click FormatCellsAlignment tab Click to uncheck* the "Merge cells" box OK *you may to click more than once to uncheck P/s: Avoid using merge cells. To center col labels across cols w/o merging, use "Centre across selection" option, under Text alignment (Horizontal) droplist in the same Alignment tab -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Cell Merge
Typo in the *note:
.. Click to uncheck* the "Merge cells" box OK *you may have to click more than once to uncheck -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Cell Merge
Is the workbook shared?
Unshare it to make unmerge available. Gord Dibben MS Excel MVP On Mon, 14 Sep 2009 10:09:02 -0700, HM wrote: I have a spread sheet with a few merge cells that I can not unmerge. I've used the on-line help but was still unable to find the right operation to unmerge. While on-line I did see this note Note If the Merge and Center button is unavailable, the selected cell may be in editing mode. To cancel editing mode, press ENTER. But it still did not allow the cells to be split. The sheet is not lock protected, any advise? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel conditional cell merge | Excel Discussion (Misc queries) | |||
| EXCEL CELL MERGE | Excel Worksheet Functions | |||
| help on excel merge cell | Excel Discussion (Misc queries) | |||
| Excel should let me use the merge and center with unprotected cell | Excel Discussion (Misc queries) | |||
| Excel should merge cells without removing content of any cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
