Creating column

  • Thread starter Thread starter AAA1986
  • Start date Start date
A

AAA1986

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

Ex. 2001, 2002, 2003, 2004
 
Hi,

Type 2001 in any one cell (say G1) and then in G2, type =G1+1. COpy this
formula down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

year cant change 2
Averageif year=2000 5
Conditions 2
Simultaneously updating Charts in Multiple sheets 1
converting text into years 4
cant edit format cells 3
Returning the smallest value above a certain criteria 4
How to retrieve last date and amount from columns? 5

Back
Top