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

#### Ufoo

##### Member
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.

#### Attachments

• 8.6 KB Views: 3

#### bosco_yip

##### Excel Ninja
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

##### Member
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.

##### Member
Hi

If you have office 365.

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

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

#### vletm

##### Excel Ninja
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

##### Member
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.