How do you create a sequence of numbers in Excel?

Answer 1

One way would be to type in the first two numbers of your sequence. Then select both numbers. Then using the Fill Handle, which is the black square in the bottom corner of the selected cells, drag down and the numbers will start to fill. So if you had 5 and 10 as the first two numbers, then it would continue on to show 15, 20, 25 etc.

Answer 2

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.

Answer 3

There are a number of ways of doing it. Say we start at 1, in cell A1. One way is to drag the fill handle while pressing the Ctrl key, which will put 2 into the next cell, 3 into the next and so on. If you put 1 into the first and 2 into the second and then select both and drag the fill handle it will put 3 into the third cell, 4 into the fourth cell and so on. With 1 in A1 you could put the formula =A1+1 in the next cell and use the fill handle to copy the formula into the other cells. You could put the formula =ROW() in A1 and fill down or =COLUMN() in A1 and fill to the right.