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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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.

2 replies

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
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