Hello, don't know if you figured this out yet.
Say you want column A numbered:
Place a 1 in A1.
In A2, type =A1+1 and press <ENTER>.
Right-click on A2 and select COPY.
Now click on A3 and drag as far down in the A column as you want to go with the numbering. Press <ENTER>.
That's it.
Wayne
Testimonial: "most excellent!!!"
You can number rows in a column by entering a number in cell A1 (usually the number 1 but youcan start with any number) and the formula (=A1+1) in the next row. The result there will be 2. Copy that formula down the rows you want to number and they will be numbered 3, 4, 5, etc. Each row adds 1 to the previous row so if you do anything that disrupts the sequence (like inserting a row between two others) you will have to copy the formulas down again to restore the sequence.
You can also use the Edit-Fill-... menu command to put a series of numbers into rows. Put the starting number in th efirst row. Highlight it and the rows that you want to number and select Edit-Fill-Series... Those numbers will not change if you insert columns or move the formulas.
Or you can use the formula =ROW(A1) in any cell to return the number of that row. (The result of =ROW(A1) is the number 1 in cell A1, the result of =ROW(A2) is the number 2 in cell B2, etc. In this case inserting rows will not affect the numbering (i.e. row A5 will always be numbered 5 even if the data in it is moved down.)
Testimonial: "Most excellent ! That was the formula I needed. I had to fiddle with it a bit-when it is typed in leave off the parenthesis. Thanks."
166 views
Usually answered in minutes!
×