Hello,
I have a column that I want to insert number 1 through ? incrementing by one. Can I do this simply without having to type in each one manually?
Thank you,
Odisey
Hello,
I have a column that I want to insert number 1 through ? incrementing by one. Can I do this simply without having to type in each one manually?
Thank you,
Odisey
Last edited by Odisey; 10-10-2008 at 11:43 AM.
If you type a 2 below it, then highlight the both of them, and drag down using the lower right corner, Excel will automatically advance the series. FYI, it would work with other simple arithimetic series too (eg. 2,4,6 or 1,3, 5 or 10,9,8). Did that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Make a1 the number 1
Make a2
=A1+1
Then copy A2 down to Awhatever as many rows as you want. It'll adjust the a1 accordingly, and every cell will add one to the number above it.
The problem with that method is that it gets screwed up if you later decide to sort the column on the basis of another column, at least if you do it via the simple AutoFilter. I tried this the other day the formulas moved around and thus some of them created circular references and whatnot.
The simple fill option is probably best in that case.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks