Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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= |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) |