
How to number in Excel
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...