Looking to Auto Add Serial Number below each line in Excel or GoogleSheet Automatically?

So we need to add a new line but find it difficult to Auto Add Serial Number below each line in Excel using any program or Software we use to copy new lists of people or product. In that case use the below code using the programto automatically add a new number to the next line.

=INDIRECT(ADDRESS(ROW()-1,COLUMN())) + 1

You can also add this code to any program such as Pabbly or Zapier to automatically copy new leads to Google Sheet. To install Pabbly for free Click Here – you can copy upto 100 tasks in the free version every month.

Thats it we Auto Add Serial Number below each line in Excel

Thank you for Reading! Do leave a comment if you found this tutorial helpful! You can also check ‘How to download Pinterest videos, by clicking here.