Drag Copy

  • Thread starter Thread starter jchandler0614
  • Start date Start date
J

jchandler0614

Can someone tell me if you can use the CTRL drag options to keep the same
cell contents when copying, but also keep various fill colors?
 
Hi,

We need a little more detail - are you trying to fill down or to the right?
are you trying to copy from one cell to a different cell which is not
adjacent? Where are the colors - in the cells you are copying or in the
target cells?
 
an addition to my last post -

If you are selecting 10 cells to fill down and you want to retain their
values and their colors, highlight the cells and drag the fill handle without
the Ctrl key and when you release the mouse open the Auto Fill Option button
at the bottom right corner of the filled area and choose Copy Cells.
 
Back
Top