How to generate numbers 0,1,2,3 in adjacent cells

[Ufoo]

Hi excel gurus. I want a formula to help me have numbers starting with 0 along rows and columns. Please see the attached excel sheet. The ROW(A1) or COLUMN(A1) is ok but I cannot get it to start with 0. I will appreciate your help.

 

[bosco_yip]

Try to use :

=ROW(A1)-1

or

=COLUMN(A1)-1

copied down or copied across right in generate numbers 0,1,2,3..........


Regards

 

[Ufoo]

Try to use :

=ROW(A1)-1

or

=COLUMN(A1)-1

copied down or copied across right in generate numbers 0,1,2,3..........


Regards

Thanks a lot. I had just discovered the formula.

 

[Kevin@Radstock]

Hi

If you have office 365.

For the horizontal numbers: =SEQUENCE(,8,0,1)

For the vertical numbers: =SEQUENCE(11,,0,1)

 

[vletm]

Ufoo
Without any formulas ...
Write to left-top-corner number 0 and one cell right side 1 >> select those cells and pull from right bottom corner as far as You needs.
Write (if needs) to left-top-corner number 0 and one cell below 1 >> select those cells and pull from right bottom corner as far as You needs.

 

[Ufoo]

Ufoo
Without any formulas ...
Write to left-top-corner number 0 and one cell right side 1 >> select those cells and pull from right bottom corner as far as You needs.
Write (if needs) to left-top-corner number 0 and one cell below 1 >> select those cells and pull from right bottom corner as far as You needs.

Thanks Ninja. ROW(A1)-1 works quite well. Your suggestion will help me when I do not need to include the numbers in a formula.