View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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.