How to number in Excel and Google Sheets using Autofill

Click here for our YouTube video on How to number in Excel

We’ll show you how to number in Excel, and even take it a step or two further so you can see how you can use Excel’s Autofill features to speed up tasks that would otherwise need to be done by typing in data.

So for this example, we’ll start off with a blank sheet (the technique is the same in Google Sheets as it is in Excel).  Let’s say for example we want to create a numbered list from 1 to 10, but can’t be bothered typing in all those numbers.  All we need to do is give Excel a hint at what we want to do, and Excel will take it from there!  So let’s start off by typing in the number 1 in a cell, and then in the cell directly beneath, the number 2.:

 

Next, you need to select both of these cells with data in, so just click in one of them, and drag so that they are both selected:

 

Now here’s where the magic happens, see the image below where to click (the little black square on the bottom right of your selection), drag this down 8 more rows and the numbers 3 – 10 will fill in automatically!

 

The end result:

 

Now this may have resolved your problem already, but before you head off and start numbering all your lists in Excel, stick around and we’ll show you how to take this a step further.  Let’s say instead of 1 to 10, we wanted all the multiples of 10, from 10 to 100.  So instead of starting off our list with a 1 and 2, we type in 10 and then 20:

 

The end result:

 

But wait, we can do so much more!  Here are examples of what the first 2 lines do once we drag them down:

 

So have a play around, and see what kinds of data you can save time on by using Autofill.

Take a look at our YouTube video if you need a bit more of a practical example of how to do this:

Leave a Reply

Your email address will not be published. Required fields are marked *