Extend the numbers 1,2 to get 3,4,5,.....
 

Dear community,

I generally know how to obtain 3,4,5,.... having 1 and 2. I just need to
select both cells and then drag the fill handle over the range. But very
recently the Drag thing disappeared completely. Do you know how I can return
it back?

Thank you very much.

Extend the numbers 1,2 to get 3,4,5,.....
 

From the Menu Bar:

<Tools <Options <Edit tab,

And check "Allow Cell Drag & Drop".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"peter_sagg" wrote in message
...
Dear community,

I generally know how to obtain 3,4,5,.... having 1 and 2. I just need to
select both cells and then drag the fill handle over the range. But very
recently the Drag thing disappeared completely. Do you know how I can return
it back?

Thank you very much.

Extend the numbers 1,2 to get 3,4,5,.....
 

In xl2003 menus:

Tools|Options|Edit Tab|check Allow cell drag and drop

peter_sagg wrote:

Dear community,

I generally know how to obtain 3,4,5,.... having 1 and 2. I just need to
select both cells and then drag the fill handle over the range. But very
recently the Drag thing disappeared completely. Do you know how I can return
it back?

Thank you very much.

--

Dave Peterson