Comments on: How to Number Rows in Google Sheets (Add Serial Numbers)

By: Gajanan

Gajanan — Tue, 12 Sep 2023 13:14:02 +0000

Hi,
I am not getting correct serial numbers when I use OR function additionally in this =IF(ISBLANK(B:B),””,COUNTA($B$4:B6)) function to add other exclusions.
Kindly help in this regard. Please see this Google Sheet https://docs.google.com/spreadsheets/d/1Or6KnzBrQ8RiSptwz64kgxh-v1kXpwzPhCHmwlWlruI/edit?usp=sharing

By: Gajanan

Gajanan — Sun, 10 Sep 2023 12:14:08 +0000

In reply to A Uddin. Me too

By: A Uddin

A Uddin — Sat, 30 Jul 2022 16:37:56 +0000

Thank you! The formula =IF(ISBLANK(B:B),””,COUNTA($B$4:B6)) really helped me organize my rows with numbers.

I love it that it also updates all the row numbers if I insert a row in the middle.

By: Donita

Donita — Thu, 16 Jun 2022 07:44:45 +0000

This was helpful! I always use excel than Google sheets that’s why I only type “1” then drag it down but it only repeats the value instead of a series.

By: Mohamed Rafik

Mohamed Rafik — Thu, 17 Feb 2022 08:29:25 +0000

Thank you, it saved my time. (Double clicking will fill for entire rows tip) 🙂

By: Rizwan

Rizwan — Sat, 12 Sep 2020 07:39:34 +0000

Thank you so much for this tip. It helped me a lot.