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.

**Table of Contents**hide

**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

**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.

**Step 3: **

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

**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).**

**Step 2:**

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

⇒ Click on the **Flash Fill** command now.

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

**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.

**Step 2:**

⇒ Now copy** C2.**

**Step 3:**

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

⇒ Press **Enter.**

**Step 4:**

⇒ Now press **CTRL+V** to paste finally.

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

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.

**Step 2:**

⇒ Now copy** C2.**

**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.**

**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.

**Step 5:**

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

**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: **=SEQUENCE(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.

**Step 2:**

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

**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.

Awesome!!!