G Guest Oct 1, 2004 #1 how do u, without manually doing it, insert down a column in increments of 10. pls email me at (e-mail address removed)
how do u, without manually doing it, insert down a column in increments of 10. pls email me at (e-mail address removed)
K kkknie Oct 1, 2004 #2 Enter 10 in first row, 20 in second row, select both rows, grab th bottom right corner of the selection and drag down.
Enter 10 in first row, 20 in second row, select both rows, grab th bottom right corner of the selection and drag down.
G Gord Dibben Oct 1, 2004 #3 D.L. Enter first number in top cell of column. Select range to fill. Or entire column. Edit>Fill>Series. Check "Column" and "Linear". Enter 10 in "step value". If entire column selected, enter a "Stop Value" Gord Dibben Excel MVP On Fri, 1 Oct 2004 07:57:07 -0700, "D L Barnard" <D L
D.L. Enter first number in top cell of column. Select range to fill. Or entire column. Edit>Fill>Series. Check "Column" and "Linear". Enter 10 in "step value". If entire column selected, enter a "Stop Value" Gord Dibben Excel MVP On Fri, 1 Oct 2004 07:57:07 -0700, "D L Barnard" <D L