L lost~dispatcher Jan 18, 2010 #1 I put my number in A:1 and need the system to add the rest in numerical order all the way to A:52. I do not remember what to do...
I put my number in A:1 and need the system to add the rest in numerical order all the way to A:52. I do not remember what to do...
C cm Jan 18, 2010 #2 select your range to fill then from the Edit menu, choose Fill and Series -- buttons are Columns and Linear, step value = 1
select your range to fill then from the Edit menu, choose Fill and Series -- buttons are Columns and Linear, step value = 1
D David Billigmeier Jan 18, 2010 #3 In cell A2 put the following formula: =A1+1 Then copy down to A52
G Gord Dibben Jan 18, 2010 #4 Right-click on the fill handle of A1 and drag down to A52 Release and "Fill Series" Gord Dibben MS Excel MVP
Right-click on the fill handle of A1 and drag down to A52 Release and "Fill Series" Gord Dibben MS Excel MVP
