CODEWITHSUNDEEP
google-sheetsauto-incrementarray-formulas
Dinesh Gurjar
Dinesh Gurjar

Reputation: 528

How to auto-increment in spreadsheets by formula?

I know this drag and drop in spreadsheets.

sheets

I want the first column with auto-increment. But I have thousands of record so how can I auto increment by any formula for a specific range or up to the bottom of spreadsheets.

I want formula like: 

=A1+1
=row(A1)+1

Upvotes: 3

Views: 6296

Answers (1)

JPV
JPV

Reputation: 27262

For a specific range (ex: first 100 rows)

=Arrayformula("S"&row(A1:A100))

Or, all the way to the bottom:

=Arrayformula("S"&row(A:A))

Upvotes: 7

Related Questions