If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto numbering 1,2,3,.....
|
#2
|
|||
|
|||
auto numbering 1,2,3,.....
Hi
see you other post -- Regards Frank Kabel Frankfurt, Germany "Richard" schrieb im Newsbeitrag ... |
#3
|
|||
|
|||
auto numbering 1,2,3,.....
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. -- Marin Kostov Microsoft Office XP Master Instructor |
Thread Tools | |
Display Modes | |
|
|