I want to suggest that single cells that were merged will retain their
original identity. This will help sort lists with merged cells. Of course,
if the sorting leaves the merged cells together, they can stay
merged--otherwise, they split up but keep the same value they had.

Keeping their identity will also help for references to the merged cells;
these references will not be lost (as they are now, set to zero) after a
merge.

Of course, the merged cells must all have the same value; if unequal cells
are merged, then they can all be assigned the value of the upper-leftmost
cell.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Not use Merged cells.
Only problems

Maybe you can use this ?

Excel 97-2003: FormatCellsAlignment Tab ... Center Across Selection
Excel 2007: In the Cells group on the Home tab use
FormatFormat CellsAlignment Tab ... Center Across Selection

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"hmm" wrote in message ...
I want to suggest that single cells that were merged will retain their
original identity. This will help sort lists with merged cells. Of course,
if the sorting leaves the merged cells together, they can stay
merged--otherwise, they split up but keep the same value they had.

Keeping their identity will also help for references to the merged cells;
these references will not be lost (as they are now, set to zero) after a
merge.

Of course, the merged cells must all have the same value; if unequal cells
are merged, then they can all be assigned the value of the upper-leftmost
cell.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc