Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() "Lino" wrote in message ... how to autonumber a range of cells 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Better autonumbering formula? | Excel Worksheet Functions |