How do I increment a column in Excel
 

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?

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

How do I increment a column in Excel
 

A more permanent method is to store each person's start date in the club.
Then use Datedif or similar formula to calculate the number of years from
Today. Then it will always be accurate, and you won't have to make changes
in the future.

Regards,
Fred

"Legion Man" <Legion wrote in message
...
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?