Excel offers a very interesting way to autofill numbers without dragging. We can cater to this problem statement by using the Fill option. We can perform the below mentioned way to autofill numbers without dragging in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with some values in a column
– Open the desired Excel workbook which contains some values in a column
Step 2 – Select the range of cells
– Select the range of cells till where you want to autofill the numbers
Step 3 – Apply the formula to autofill
– Now type “Alt + H +F + I +S”. A dialogue box will appear, hit Enter.
Step 4 – Numbers autofilled
– We can see that the numbers have now been autofilled till the range we selected.