Try right-click on fill handle and drag down
When you release, there's a pop-up menu
for you to select "Copy Cells"
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Brenda" wrote in message
...
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?
|