Locking Clolumn Color So It Won't Get Dragged Away
 

I have a spread sheet with different colored columns. I often drag
and drop data from one column to another but the color in the cells
gets dragged along leaving the cells white with no fill. Can this be
avoided. I've tried conditionally formatting the column colors but it
doesn't fix this. Thanks.

Locking Clolumn Color So It Won't Get Dragged Away
 

Hi

Try using CopyPaste Special
You then have the choice of pasting Values or Formulae, and the format
of the receiving cell(s) will not be altered.

--
Regards

Roger Govier


"Rocco_Boy" wrote in message
...
I have a spread sheet with different colored columns. I often drag
and drop data from one column to another but the color in the cells
gets dragged along leaving the cells white with no fill. Can this be
avoided. I've tried conditionally formatting the column colors but it
doesn't fix this. Thanks.

Locking Clolumn Color So It Won't Get Dragged Away
 

Thanks. I know that works but I'm just wondering if there's a way to
drag-and-drop without screwing up the colors.

Hi

Try using CopyPaste Special
You then have the choice of pasting Values or Formulae, and the format
of the receiving cell(s) will not be altered.

Locking Clolumn Color So It Won't Get Dragged Away
 

In , Rocco_Boy
spake thusly:

Thanks. I know that works but I'm just wondering if there's a way
to drag-and-drop without screwing up the colors.

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=

Locking Clolumn Color So It Won't Get Dragged Away
 

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.