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

[Closed]
Report
Posts
2
Registration date
Tuesday April 16, 2013
Status
Member
Last seen
April 16, 2013
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
What is the shortcut key to drag down in excel to create series of numbers from 1 to 10.

2 replies

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
2
Registration date
Tuesday April 16, 2013
Status
Member
Last seen
April 16, 2013
1
Please help me soon