How do I increment a column in Excel

[Legion Man]

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]

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.

 

[Fred Smith]

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