Excel makes it surprisingly easy to create different types of sequences, including one of the most well-known number patterns: the Fibonacci sequence.
Let’s walk through a simple, practical example.
What Is the Fibonacci Sequence?
The Fibonacci sequence starts with two numbers:
- 0
- 1
Each number that follows is calculated by adding the two previous numbers together.
Create the Fibonacci Sequence in Excel
Step 1: Enter the First Two Numbers
- Enter 0 in cell A1
- Enter 1 in cell A2
These are the starting values of the Fibonacci sequence.
Step 2: Enter the Fibonacci Formula
In cell A3, enter the following formula:
=A1+A2
This formula adds the two numbers above it.
Step 3: Use AutoFill to Complete the Sequence
- Select cell A3
- Drag the fill handle (the small green square in the bottom-right corner of the cell) downward
Excel automatically adjusts the formula and continues the pattern.
Result
Excel generates the Fibonacci sequence:
0
1
1
2
3
5
8
13
21
...
Each value is the sum of the two values above it.
Why This Works
Excel automatically updates cell references when you drag a formula down. This makes AutoFill a powerful tool for building sequences based on formulas, not just simple numbers.
Final Note
This technique works for many other sequences as well. Once you understand how formulas and AutoFill work together, creating custom number patterns in Excel becomes fast and effortless.