answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

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.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you create a sequence of numbers in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is charting in Powerpoint the same as charting in Excel?

Yes, they are the same. Powerpoint isn't for dealing with numbers generally, but you can set up tables of numbers and create charts from them, like you do in Excel.


What program is used to create and modify spreadsheets on Excel Answer It?

Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.


Can the fill handle create a series of numbers or dates?

Yes, you can use the Fill Handle to drag down and create a sequence of dates.


Why the formula use in MS Excel?

it means a sequence of numbers and letters to send you to a specific location. (I had this question as homework at school)


What are identified with numbers in Excel?

Rows are identified by numbers in Excel.


What is the difference between Microsoft Word and MS Excel?

Word: Is used to Create / Edit Word Processing documents Excel: Is used to Create / Edit Spreadsheet Calculations Hope this helps


Excel displays numbers as percentages?

Yes. Excel can display numbers as percentages. Do you have a question?


Is Excel better than Numbers?

The general opinion is that Excel is better than Numbers.


What are the three numbers before the Fibonacci sequence?

There are no numbers before the sequence!


How do you make a result sheet in Excel?

how to create a excel sheet


What word names an ordered list of numbers?

A sequence.


Why did Fibonacci create the Fibonacci Sequence?

I think Fibonacci wanted to find how many swirls or petals were on a flower ....... most of them are Fibonacci numbers....i think.... doin a projct......= )