In Excel how do you set up auto numbering?

Question

Similar to the numbering bullets in word?

Thanks!

Answer 1

1) type the number 1 in a cell.

2) in the second cell, type the following

= SUM(A1+1) - where the "A1" (in my example) is the cell with the number 1.

3) with the mouse, grab the bottom, right corner of the cell with the formula, and drag either to the right or drag down

Answer 2

Type a starting number in a beginning cell. Type the next number in the next cell (they don't need to be adjacent) and then select both cells plus any additional cells to match the number of empty cells in between. Then place the mouse in the lower right corner of the selection and click-drag to your desired endpoint

Examples:

Cell A1: 3
Cell B1: 4
Select A1&B1, then click bottom right of selection & drag to the right and C1=5, D1=6, etc.


Cell A1:8
Cell A5:9
Select A1 through A8, then click bottom right of selection & drag down and A9=10, A13=11,A17=12, etc.

Answer 3

Column A consists of formulas that refer to column B. The formula in cell A1 is:

=IF(B1<>"",COUNTA($B$1:B1)&".","")
This formula, which is copied down to the other cells in column A, displays the next consecutive item number if the corresponding cell in column B is not empty. If the cell in column B is empty, the formula displays nothing.

As items are added or deleted from column B, the numbering updates automatically.