software

How do I turn off the warning message that says quot;The selection contains
multiple data values. Merging into one cell will keep the upper-left most
data only.quot; I would like the merge to happen without the warning. Your help
is appreciated.
--
David P.

One approach to resolve your request is to *avoid* what the message is
warning about, therefore XL doesn't need to display it.

If *only* the top left cell of the merge range contains data, you won't get
the warning message.
Can't you delete any data in the other cells before performing the merge?
You're going to *lose* the data anyway!

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

quot;David P.quot; gt; wrote in message
...
gt; How do I turn off the warning message that says quot;The selection contains
gt; multiple data values. Merging into one cell will keep the upper-left most
gt; data only.quot; I would like the merge to happen without the warning. Your
help
gt; is appreciated.
gt; --
gt; David P.Just remembered ... there's a way to merge and *not* lose the data ... so
.... makes the warning unnecessary ... so ... XL doesn't display it!

*COPY* the merge format to a range, and the data in the adjoining cells is
not lost.
When you choose to un-merge the range, the data comes right back.

Merge an out-of-the-way range of cells, identical in configuration to the
range containing data, then copy that merged range to the cells in question,
using either the format painter, OR, quot;Paste Special - Formatsquot;.

This will give you the properties of the cell merge, *without* the loss of
data ... and of course ... without any warning messages.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;RagDyerquot; gt; wrote in message
...
gt; One approach to resolve your request is to *avoid* what the message is
gt; warning about, therefore XL doesn't need to display it.
gt;
gt; If *only* the top left cell of the merge range contains data, you won't
get
gt; the warning message.
gt; Can't you delete any data in the other cells before performing the merge?
gt; You're going to *lose* the data anyway!
gt;
gt; --
gt; Regards,
gt;
gt; RD
gt;
gt; --------------------------------------------------------------------------
-
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; --------------------------------------------------------------------------
-
gt;
gt; quot;David P.quot; gt; wrote in message
gt; ...
gt; gt; How do I turn off the warning message that says quot;The selection contains
gt; gt; multiple data values. Merging into one cell will keep the upper-left
most
gt; gt; data only.quot; I would like the merge to happen without the warning. Your
gt; help
gt; gt; is appreciated.
gt; gt; --
gt; gt; David P.
gt;That is not documented by Microsoft and you would be using it at your own risk,
specifically contrary to documentation on addressing merged cells, and if you
unmerge and then merge again the extraneous data will be lost.
Consider it an anomaly not as something to actually use.

quot;RagDyerquot; gt; wrote in message......
gt; Just remembered ... there's a way to merge and *not* lose the data ... so
gt; ... makes the warning unnecessary ... so ... XL doesn't display it!
Why wouldn't there just be something you can click in the options file to
quot;Merge cells automatically without warningquot; kind of thing? That's probably a
frustrating question that you probably wouldn't want to respond to...Thanks.
--
David P.quot;David McRitchiequot; wrote:

gt; That is not documented by Microsoft and you would be using it at your own risk,
gt; specifically contrary to documentation on addressing merged cells, and if you
gt; unmerge and then merge again the extraneous data will be lost.
gt; Consider it an anomaly not as something to actually use.
gt;
gt; quot;RagDyerquot; gt; wrote in message......
gt; gt; Just remembered ... there's a way to merge and *not* lose the data ... so
gt; gt; ... makes the warning unnecessary ... so ... XL doesn't display it!
gt;
gt;
gt;

Was simply addressing a procedure to avoid the warning message David, and
stating the reason for it's absence, *not* advocating its use to not lose
data when merging.

Although, you're correct in stating that caveat, which I should have
probably included.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;David McRitchiequot; gt; wrote in message
...
gt; That is not documented by Microsoft and you would be using it at your own
gt; risk,
gt; specifically contrary to documentation on addressing merged cells, and if
gt; you
gt; unmerge and then merge again the extraneous data will be lost.
gt; Consider it an anomaly not as something to actually use.
gt;
gt; quot;RagDyerquot; gt; wrote in message......
gt;gt; Just remembered ... there's a way to merge and *not* lose the data ... so
gt;gt; ... makes the warning unnecessary ... so ... XL doesn't display it!
gt;
gt;