Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 4/4

SEQUENCE: lists of numbers

Exercise 1 of 3

In A2, list the numbers 1 to 5 down the column.

About this lesson

SEQUENCE creates a list of numbers, such as 1 to 10, in one formula.

In this lesson

  1. In A2, list the numbers 1 to 5 down the column.
  2. In B1, list 10, 20, 30, 40 across the row.
  3. In B1, add up the numbers 1 to 10 in one formula, without typing them.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in A2 and press Enter to check.