Press the CTRL key while dragging.
Hope this helps. Please rate this post!
G.Morales
"Brenda" wrote:
I often have to copy data from a cell into the 4 cells below it. I use the
fill handle to do this. Because it is often numbers, Excel assumes i want to
fill a series and not just copy the data. Is there a way to default this to
always copy instead of filling in series?
|