View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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