Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I recently migrated to office 2010. How do I insert the numbers in excel by holding the mouse, which was possible in the older version?

share|improve this question
As explained in either answer: Type 1 in A1, type 2 in A2, drag the bottom right corner anchor down and it will fill the series. As a result A3 will have 3, A4 will have 4 and so on... – Tom Wijsman Feb 7 '12 at 15:45

The feature is still there. Just do as the picture below shows.

enter image description here

share|improve this answer
I would like to have 1,2,3,4,etc and not 1,1,1,1,1 – Anil Feb 7 '12 at 11:27
That is why I've highlighted Fill Series. Click it. – Bibhas Feb 7 '12 at 11:34

Refer my screenshots:-

Before Drag n Drop

enter image description here

After Drag n Drop

enter image description here

share|improve this answer
@Sivaand Bibhas, i could not extend the selection beyond selected text. I was comfortable in my old version. Is it a bug in my new system? – Anil Feb 7 '12 at 12:13
@Anil: Can you please provide a screenshot? It will be more clear for us.. – Siva Charan Feb 7 '12 at 12:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.