Maybe you are trying to Autonumber the rows in Excel.
here is the solution:
In cell A1 type 1.
In cell A2 type 2.
Select both cells with the mouse.
In cell A2 there is a thick square in the bottom left corner. Click it, hold
the left mouse button and pull down. Now you see a yellow boxes showing the
numbers - 2, 3, 4... and so on. If you need the numbers from 1 to 10,
release the mouse when you see 10 in the box. Now you have your auto numbers
in the Column A.
If you want sequence like Item01, Item02, make the same thing as mentioned
above.
If you need 0.5, 1.0, 1.5 - type the first and the second member of the
sequence. In that way Excel will be able to recognize the step of the
increment.
