Hi Hari

Sometimes you need one behavior, sometimes you need another. The difference
is there so that you can control it. Try dragging with the right mousebutton
and see what happens.

See also
http://www.dicks-blog.com/archives/2...e-fill-handle/
http://www.dicks-blog.com/archives/2...andle-secrets/
for more options.

HTH. Best wishes Harald

"Hari" skrev i melding
oups.com...
Hi,

In excel if I have q294bup1 in acell and I drag it down wih mouse
using the handle it updates to q294bup2 and q294bup3 and so on.

On the other hand if I press ctrl and drag it down it doesnt get
updated (remains as q294bup1 in all dragged cells)

Again if I have numbers in a cell like 1 and if I drag it down it
remains as 1 (as opposed to Q294b1 + Dragging). If I press ctrl and
drag the number 1 in a cell it increases to 2, 3 and so on ( ( as
opposed to Q294b1 + Ctrl + Dragging).

Why this different behaviour(s) regarding to dragging vs Ctrl +
dragging depending on what one has in a particular cell

Regards,
Hari
India