How to auto fill numbers in excel without dragging

How to auto fill numbers in excel without dragging

  • Post author:
  • Post category:Formula

If you can use excel the right way, I don’t see any need to reach out for your calculator to do the math. Excel just needs some simple formulas and the whole work is done. However, using excel especially if you are new to it can be stressful and time-consuming. Now, most people want to fill numbers in each cell at a time. Although this is the basic knowledge that you learned at school or through your friend, there are several other ways you can perform the task without spending as much time. In this post, I will show you how to autofill numbers in excel without dragging.

Excel is not just for making tables. Am pretty sure when you were in school, you used Excel in several ways. In school, you might have used it to create some few tables or even add some few cells. Although this is one of the most basic uses of Excel, this Microsoft Office application is very complex and involves something more than this. Experts use excel to organize data, do basic and complex mathematical functions so that you don’t have to do the same thing yourself. It can as well help people turn piles of data into helpful and simple to interpret graphics and charts. Other professionals including economists use excel to analyze data and later make reliable predictions.

If you have the right excel knowhow, then you can get better at your job. Accountants and investment bankers are not the only people that need to know all the insights about excel. As a matter of fact, excel should be a basic requirement for most employees.

What do you do when you have to fill 1-1000 in a column in excel? We can both agree that this can take much of your time and tire you. Your friend told you that you have to use the regular way method of filing these numbers which involve:

Entering 1 in cell A1

Entering 2 in cell A2

Then select both cells and later drag it down
to the last cell using the fill handle.

Although this can work the same, sometimes it can be irritating to drag the fill handle to the last cell. It can be a problem especially when you are dealing with many numbers. Now in this post, am uncovering the simplest of all auto methods of doing this. Don’t waste a lot of your time, follow the below steps to make it a reality. The above are some of the reasons why you should learn and know all about excel.

The big deal now comes when some of the users know the long tricks of using excel. If you take time to look around, you will notice that there are some users that are using this MS application a little fast which means they have some tactics that ease their work. This is exactly why you should as well learn some simple tactics of making it this simple. With each version, there’s always a simplification in its usability which is making it very easy and simple to navigate with each coming version.

The MS excel tools are very useful in making work easier. As a matter of fact, there are a couple of tools including sorting, filtering and searching
which eases your overall hustle. In this blog and the coming ones, we will take actions and help you perform some simple actions on Excel with ease.

Enter 1 in cell A1 just like you did with the regular method.

Now retire back home-editing-fill-series. You can get a clear picture below. If you are not getting the fill command directly, come down from the Autosum symbol.

Now you should make the following selections in the dialogue box.

Type: Linear

Stop value select 1

Stop value select the last number you want on your sheet. In our case, select 1000.

Series in: select row or column where you want the numbers to be inserted. In this case, you select Columns.

Now make sure the selections are as shown in the screenshot above. If all the selections are filled the right way, now it’s time to check for the results. Click okay and move on.

This selection will fill the cells A1: A1000. The numbers will be shown down from A1-A1000 which is what you wanted. As I had already stated, you can add the numbers on the row instead of the column. To do this, you should select Rows
in the series instead of the Columns as it was in our case. There are some of the instances when you want to start on a number rather than one. In this case, you should fill that number in cell A1 and at the same time select the bottom number.

The above process doesn’t mean all the numbers will follow in an interval of 1. If you want to choose a different step, let’s say the difference between the numbers in each cell to be 2-3-10, then you should select the interval you want. This means you can select 2
if you want the interval between the recurrent numbers to be 2.

The above step becomes very useful when there are a couple of numbers you want to add in the rows or the columns. However, if you just need to add numbers in two or three cells, the wisest thing to do is to add them manually. Though, if there are hundreds of cells that need to be added, it becomes tricky and dragging is not the easiest and the best trick here.