Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag Copy
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag Copy
Have you tried dragging with and without pressing Ctrl to see what happens?
Tyro "jchandler0614" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag Copy
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? -- Thanks, Shane Devenshire "jchandler0614" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag Copy
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. -- Thanks, Shane Devenshire "jchandler0614" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Command; Drag and Drop | Excel Discussion (Misc queries) | |||
Copy drag formula down cells | Excel Worksheet Functions | |||
Can we drag-copy cells from evry five row to every row | Excel Discussion (Misc queries) | |||
Drag copy between worksheets | Excel Discussion (Misc queries) | |||
In Excel, how can I stop the drag function to copy and not add? | Excel Worksheet Functions |