On Tue, 21 Nov 2006 19:34:04 +0000 (UTC), Dallman Ross
<dman@localhost. wrote:

What I tend to do is, drag, let the colors or formatting be
temporarily screwed up, then click in the little box that
temporarily appears once I've let go of the mouse from dragging,
and select "Fill Without Formatting" or "Match Destination Formatting,"
depending on what kind of paste operation it was I just did.

=dman=

I do the same. But then you have to go back and fix the cells you
dragged from because the formatting was dragged away. Seems there
should be a way to prevent this. Maybe not.