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?