How to Autofill Numbers in Excel without Dragging (5 Quick Methods)

Microsoft Excel provides numerous ways to autofill numbers with or without dragging. Filling down the column is the most common method to complete a series.

But if you don’t want to drag to autofill numbers, this article should help you through the following guidance with other useful methods.


Download Excel Sheet to Practise

You can download the practice sheet here which was prepared while writing this article.


5 Methods You Can Apply to Autofill Numbers in Excel without Dragging

1. Using the ‘Fill Series’ Option to Autofill Numbers

For example, you want the multiples of a number within a fixed range.

We’re going to find the multiples of 15 here up to 200.

Step 1: 

⇒ Go to Home

⇒ Go to the Editing group of commands

⇒ Click on the Fill drop-down

⇒ From the drop-down select Series command

using fill series to autofill numbers in excel without dragging

Step 2: 

You’ll find a box with multiple options to choose from.

⇒ Insert 15 as Step Value; it’ll count the steps or intervals to show the next all value sequentially.

⇒ Type 200 inside the box of Stop Value; it’s the final value of your range within which you want to see the results.

using fill series to autofill numbers in excel without dragging

Step 3: 

⇒ Click OK and you’ll see all the multiples of 15 within 200 at once.

using fill series to autofill numbers in excel without dragging


2. Using Flash Fill to Autofill Numbers

This option is really interesting if you want to fill a series with a pattern.

Suppose, you have a list of names and ID numbers of some students in a school.

You only need their ID numbers.

Step 1:

⇒ Type the first ID number from Cell A2 in the column of ID(Column B).

using flash fill to autofill numbers in excel without dragging

Step 2:

⇒ Like the previous process, select Fill drop-down under the Home tab.

⇒ Click on the Flash Fill command now.

using flash fill to autofill numbers in excel without dragging

The ID numbers of all students in your list will be displayed right away.

using flash fill to autofill numbers in excel without dragging


3. Editing Name Box to Autofill Numbers in Excel

Now here you’re seeing a chart of some pizza items with their prices.

You want to calculate the final prices with 7.5% VAT.

Let’s do it for the first case manually.

Step 1:

⇒ Multiply B2 with 1.075(for 7.5% VAT the multiplier will be 1.075) at Cell C2.

You’ll get the final price including VAT for the item Margherita.

editing name box to autofill numbers in excel

Step 2:

⇒ Now copy C2.

editing name box to autofill numbers in excel

Step 3:

⇒ Go to the Name Box and type your cell range C2:C11 for calculation.

⇒ Press Enter.

editing name box to autofill numbers in excel

Step 4:

⇒ Now press CTRL+V to paste finally.

You’ll get all the final prices including VAT for all pizzas under Column C.

editing name box to autofill numbers in excel


4. Copying Formula(s) and Then Navigating to Paste to Autofill Numbers

You can evaluate the final prices with VAT in another method which won’t need to insert range in the Name Box.

Step 1:

⇒ Like the previous method, calculate the final price at C2 for the first one.

copying and pasting formula to autofill numbers in excel

Step 2:

⇒ Now copy C2.

copying and pasting formula to autofill numbers in excel

Step 3:

⇒ Navigate to B2 by pressing the Left Arrow key.

⇒ Press CTRL+Down Arrow key to reaching the last cell (B11) in column B.

copying and pasting formula to autofill numbers in excel

Step 4:

⇒ Navigate to C11 with the Right Arrow key and press the CTRL+Shift+Up Arrow key.

It’ll select the whole column range (C2:C11) where you need the overall calculated results.

copying and pasting formula to autofill numbers in excel

Step 5:

⇒ Press CTRL+V to paste and you’ll find your desired results in column C.

copying and pasting formula to autofill numbers in excel


5. Applying the SEQUENCE Function to Autofill Numbers

‘Sequence’ is another useful function to execute the series by auto-filling.

For example, you want a series starting from 5 and with a common difference of 12.

You want to get the 1st 15 values in this series.

Step 1:

⇒ In the Function Bar, type: =SEQUENCES(15, 1, 5, 12)

Here inside the bracket,

15 denotes the no. of rows you want to see.

1 is for column no.

5 is the initial value you want to start from.

And 12 is for the common difference which you’ll find as Step Value in the Function Bar during typing.

applying sequence function to autofill numbers in excel

Step 2:

⇒ Press Enter and you’ll get the full series with a common difference of 12.

applying sequence function to autofill numbers in excel


Conclusion

These are all basic and very effective methods and functions you can use to autofill a series of numbers without dragging or filling it down. If you have any suggestions or opinions on this article let me know in the comment box.


Further Readings

Nehad Ulfat

Hello, Welcome to my profile. I'm a Technical Content Creator as well as a Naval Architect & Marine Engineer. I have preferences to do analytical reasoning & writing articles on various statistical data. Here, you'll find my published articles on Microsoft Excel & other topics related to my interests!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo