ExcelBanter - Creating column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating column (https://www.excelbanter.com/excel-worksheet-functions/260139-creating-column.html)

AAA1986

Creating column

I would like to create a column that automatically adds one for each row.

Ex. 2001, 2002, 2003, 2004

Ashish Mathur[_2_]

Creating column

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

All times are GMT +1. The time now is 11:45 AM.