R rafonss Sep 4, 2008 #1 I would like to start numbering 1 - 500 in a column and 1 - 30 in a row. Is there some way to do this with a function?
I would like to start numbering 1 - 500 in a column and 1 - 30 in a row. Is there some way to do this with a function?
P Pete_UK Sep 5, 2008 #2 There are many ways of achieving this, but if you want a function then the easiest is to put 1 in your starting cell (suppose this is A1) and then in A2 put this formula: =A1+1 and copy this down. In B1 you can enter this formula: =A1+1 and copy this across. Hope this helps. Pete
There are many ways of achieving this, but if you want a function then the easiest is to put 1 in your starting cell (suppose this is A1) and then in A2 put this formula: =A1+1 and copy this down. In B1 you can enter this formula: =A1+1 and copy this across. Hope this helps. Pete
M Milan L Feb 23, 2009 #3 Hi, this did not work for me. Copying =A1+1 in A3 always give me 2 instead of number 3. am i reading your note correctly? thanks
Hi, this did not work for me. Copying =A1+1 in A3 always give me 2 instead of number 3. am i reading your note correctly? thanks
G Glenn Feb 24, 2009 #4 Another option...in the first cell of the column you want to number from 1-500 put =ROW(1:1) and fill down as needed. In the first cell of the row you want numbered from 1-30 put =COLUMN(A:A) and fill right as needed.
Another option...in the first cell of the column you want to number from 1-500 put =ROW(1:1) and fill down as needed. In the first cell of the row you want numbered from 1-30 put =COLUMN(A:A) and fill right as needed.
