How To Add Column/Row Number Automatically?

[Sh1]

This is how I do it

The first cell I wrote =1
2nd A3 I wrote =A2+1 and then I repeat, Is there is a better way to do it?

[LeroyG]

Hello @Sh1, Please, edit the title and change Raw by Row. Thanks.

[Sh1]

@LeroyG I have edit it, Thanks.

[Zizi64]

=ROW()

=COLUMN()

Just copy or drag the formula down/right.

Maybe you need use an offset value:

=ROW()+1

=COLUMN()+1

[anon73440385]

Hello

alternative methods to avoid evaluations.

Method 1 - Drag down

• Enter 1 in to first cell

• Drag down on the black handle in the lower right corner of the cell

  

Method 2 - Fill Series

• Select a column
• Menu Sheet -> Fill Cell -> Fill Series...
• Enter a Start value.
• Enter a End value.
• Click OK

Hope that helps.

[Sh1]

Thank you.