fill handle
 

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?

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?

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?

try it w/o the fill handle. select the cell AND other cells you want
fillededitfilldown

--
Don Guillett
SalesAid Software

"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?

Select cell with data and highlight down to end of range-hit Ctrl + D. This
will copy the selected data down to the end of the highlighted range
Pat F

"Don Guillett" wrote:

try it w/o the fill handle. select the cell AND other cells you want
fillededitfilldown

--
Don Guillett
SalesAid Software

"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?