How to Create Fibonacci Sequence in Excel

This is Excel tutorial on how to make Fibonacci numbers form a sequence. After two starting numbers, the next number in the sequence is the sum of the two preceding numbers. 

The Fibonacci ten numbers in the Fibonacci sequence are: 0, 1, 2, 3, 5, 8, 13, 21, 44, 65.

Preparing Fibonacci sequence formula

Here are the steps to creating a Fibonacci sequence in Excel:

Click on cell A1 and type the number "0" in it.

Click on cell B1 and type the number "1" in it.

Click on cell C1 and type "=A1+B1" in it

Fibonacci type sum

How to Create Fibonacci Sequence?

To copy the formula to the adjacent cells, place the mouse pointer on the bottom right corner of cell C1. You will see a black plus sign. Drag the plus sign to cell P1. You will see the number "612" in cell P1.

Fibonacci drag plus sign

(optional) To continue the Fibonacci series, continue dragging to the right.

Fibonacci continue dragging

This will generate the Fibonacci sequence automatically.