Microsoft Excel Functions & Formulas

Incrementing row numbers

Standard row numbering in Excel is often used, but you can also

create your own numbering system in a table, such as incrementing

by 10 as described below.

4

To increment row numbers by 10:

1. Select cell A2 and type 0.

2. Select cell A3 and type the following formula: =A2+10.

3. Select cells A3:A12.

4. From the Edit menu, select Fill and Down.

Note: If the value of cell A2 is changed, the values in all

other cells change too.

Formulas in Excel

11

1

Figure 1-10