Formula for creating identity column in Excel
A more versatile approach (no copying down etc) is Series Fill, on the Ribbon under HOME > Editing - Fill. Seed the start cell with the start value (1
in the example), if necessary reselect it, and as shown if to increment by 1
down a column one hundred times:
Can be across a row instead, dates etc, but the main advantage over =A1+1
may be that no formula is involved.
Josh
Goal oriented, fast paced, skilled and knowledgeable. Learns new languages and concepts quickly and can apply them efficiently in work. Strong communication skills and actively drives for progress every day. Very friendly, professional, and am known for getting along great with coworkers. Extremely client driven and results oriented. Along with providing expert programming to every project, also has the knowledge in business strategy and marketing to make it succeed. Balances the desire for ever reaching scopes and technical perfection with the real world of budgets, time constrains, and scope change to deliver products that consistently deliver a great business value.
Updated on November 22, 2022Comments
-
Josh over 1 year
I'm sure my terminology is off, I just want a formula to put in a column in excel where each cell equals the cell above it + 1. End result I make the first cell 1 and the rest count up from there. Maybe there's a more correct way to do this. Suggestions?
-
Ken White about 12 yearsSO is for programming-related questions, not general software use questions. For that we have SuperUser. I've voted to move your question there, where it is more suitable. Thanks. :) (And you can just use
=A1 + 1
in cellB1
, and then copy the formula down as many rows as you'd like. It will adjust the formula for you automatically as long as you don't use absolute references.) -
Jerry Beaucaire about 12 yearsI believe he means put =A1+1 in cell A2 and copy down.
-