Fill a column with a series of numbers

How to add a number range such as 1,2,3, up to 1000 but without typing them in.

I couldn’t remember how to do this so a quick check revealed the solution.

Thank you M$ support.

Fill a column with a series of numbers

  1. Select the first cell in the range that you want to fill.
  2. Type the starting value for the series.
  3. Type a value in the next cell to establish a pattern.

    TIP   For example, if you want the series 1, 2, 3, 4, 5…, type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8…, type 2 and 4.

  4. Select the cells that contain the starting values.
  5. Drag the fill handle Fill handle across the range that you want to fill.