If you normally type 1 & 2 below, and then select and drag it down, it will create a series/list of 1, 2, 3, …
But if you want to create a series/list of only odd numbers 1, 3, 5, …, follow these steps.
Let’s say you want the series to appear in Column E, starting from cell E1.
- In cell E1, type 1.
- Select the Entire E column.
- Go to Home Tab – Fill, and click on Series..
- Press Ok.