G Guest May 30, 2005 #2 What do you mean by auto nummber You could do the following a b 1 1 Enter 1 for the first cell 2 =max($A$1:A1)+1 then drag down 3 =max($A$1:A2)+1 it will produce this second formula 4 5 HTH
What do you mean by auto nummber You could do the following a b 1 1 Enter 1 for the first cell 2 =max($A$1:A1)+1 then drag down 3 =max($A$1:A2)+1 it will produce this second formula 4 5 HTH
V Vic Sowers May 30, 2005 #3 Lino said: how to autonumber a range of cells Click to expand... Enter into the first two cells in the column: 1 2 Then select both cells and dreag the little square down as far as needed. - Or - Enter 1 into the fist cell in the column and =<the cell with 1 in it>+1 (e.g. A1+1) Then select the second cell and drag it down as far as needed.
Lino said: how to autonumber a range of cells Click to expand... Enter into the first two cells in the column: 1 2 Then select both cells and dreag the little square down as far as needed. - Or - Enter 1 into the fist cell in the column and =<the cell with 1 in it>+1 (e.g. A1+1) Then select the second cell and drag it down as far as needed.
