How do I increment a column in Excel
What's in that column?
If it's just a number/counter:
Put 1 in an empty cell
Edit|copy that cell
select the range to adjust
Edit|paste special|check Add and Values
Clean up that cell with the 1 in it.
Legion Man wrote:
Have a column of 318 members in a club. Want to increment the entire column
by one for each additional year they are active. How do I do this with the
operations available in Excel?
--
Dave Peterson
|