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.

  1. In cell E1, type 1.
  2. Select the Entire E column.
    Select E Column
  3. Go to Home Tab – Fill, and click on Series..
    Click on Series

    • Series in – select Columns.
    • Type – select Linear.
    • Step Value – select 2.
    • Stop Value – Let’s say you want to stop the number series generation and 49, then type 49; else leave it blank.
      Series Options
  4. Press Ok.
    Result