Increment Question

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Can anyone explain how to setup an automatic simple increment counter. I
just want the first column in each row to increment by 1 so it would be like

1
2
3
4 and so on....

Your help will be greatly appreciated.

Chris
 
Chris,

Some ways

- enter 1 in A1. Then hold down the Ctrl key and fill down A1
- enter 1 in A1 and 2 in A2. Then select A1:A2 and fill down
- enter 1 in A1. Select A1:A100. Do Edit>Fill>Series Step=1

To fill down, point at the little black square in the bottom right corner of the cell and drag down.

HTH
Anders Silven
 
Back
Top