Hi,

Type 2001 in any one cell (say G1) and then in G2, type =G1+1. COpy this
formula down

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"AAA1986" wrote in message
...
I would like to create a column that automatically adds one for each row.

Ex. 2001, 2002, 2003, 2004