What is the shortcut key to drag down in excel to create series

Closed
Anil Maharana Posts 2 Registration date Tuesday April 16, 2013 Status Member Last seen April 16, 2013 - Apr 16, 2013 at 03:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 16, 2013 at 10:52 AM
What is the shortcut key to drag down in excel to create series of numbers from 1 to 10.
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 16, 2013 at 10:52 AM
Hi Anil,

How do you imagine how that would work?

Like select A1 hit shortcut key and then range A1:A10 is filled with numbers (1:10).
Or
Select A10 hit shortcut key, then look at first value above A10. For example A1 has value 3, then range A1:A10 is filled with numbers (3:13).
Or
Select a range and fill it with numbers.

Do you only want numbers from 1 to 10?

Please clarify.

Best regards,
Trowa
1
Anil Maharana Posts 2 Registration date Tuesday April 16, 2013 Status Member Last seen April 16, 2013 1
Apr 16, 2013 at 03:07 AM
Please help me soon
0