How to Automate Row numbers in Excel?

Use ROW functionality and save time while updating your plans. The Excel ROW function returns the row number for a reference. For example, ROW(C10) returns 10, since C10 is the tenth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.

[@LoomaHat]

Thanks!

[@ExceltoExcelE]

@loomaHat Thank you so much for your $2 thanks! Your support means a lot to me and helps keep this channel going. I'm grateful for your generosity and for being part of our community. I am so happy that you found the video interesting and useful.

[@baraal-hakima.3865]

Thank you so much for the straightforward tutorial. This is the exact video I’ve been looking for.

[@ExceltoExcelE]

Thanks so much for watching the video and sharing your valuable comments here. I am glad that you could benefit from the video. Please stay in touch for more such videos on my channel and don't forget to subscribe.

[@SeanGuyDude]

I want to use this formula (or a similar one) to add reference numbers for each row (containing client addresses) on the spreadsheet. Is there a way that I can make it so that it doesn't just use the row number but instead could be like GA1.1, GA1.2, GA1.3, etc? Thanks in advance!

[@muhammaduuu]

Please can u do that with calculations. For example A1 + B1 =C1 can this formula work automatically without the stress of dragging.

[@souweaver07]

How do you auto update the row numbers inside a formula. Eg, countif(A1:a5,""), I want A5 to automatically update inside a formula when I the row number in a different cell.

[@diamondeyes2417]

How do I increase numbers by a percent amount already in the spreadsheet

[@hetch.8048]

For counting from second row, use
Row( )-1
Thank me later.

[@sherryjohnoommen]

I just want to thank you now :) before I forget to do that!! And thanks to Excel to Excel presenter for the quick short, sweet & straight hit presentation

[@Roobivanz]

Thanks a lot dude

[@Han_Ngoc_Quang]

Thank you, very straightforward tutorial.

[@ExceltoExcelE]

Thank you Hanoi for the note and watching the video. Please stay in touch for more such videos on my channel.

[@scott_hanna]

For those of you that have asked if the list starts at row 2 and not row 1:
If you enter “=row()-1” (without the quotations) it will work for you. You can change “-1” to whatever you need it do be to make up the difference of where the actual list starts verses the row number.

[@ExceltoExcelE]

Thanks a million Scott for sharing the trick.

[@dominicbacaling8606]

THANKS!

[@_crescent_12_-]

thank you!

[@bla8358]

Thankss❤

[@mlltbmrsll]

Thank you very much! ☺

[@dylan4331]

Thanks ❤ gratefulness to TH-cam and this video creator☺️

[@ExceltoExcelE]

❤️❤️❤️ Thanks for watching the video and sharing your valuable comments here. Stay blessed.

[@Lanreodusina]

Thanks for this simple teaching.

[@ExceltoExcelE]

Glad it was helpful! Thank you for your comment and for watching the video

[@akindeleabiola6536]

This really helps. Thank you.

[@ExceltoExcelE]

I am so happy that the video was useful for you. Thanks for watching the video and sharing your thoughts. Please stay in touch with my channel for more such videos.

[@radu0505]

!!!!!!!!!!!!!!!!!!!Need so help plz!!!!!!!!!!!!!!!! I want to create a simple table with numbers from A1:A10. In cell B1 I want to type the number in, and have that number automatically enter in the table in cell A1. Than when i type the second number in cell B1, i want the number from A1 to drop to A2 and have the new number go on top "A1". I want to do this each time i type a new number in cell B1. How can i create this rule????

[@ainwni]

This video very helpfu!!! and easy to understand!! Thanks a lot

[@ExceltoExcelE]

Thank you indeed for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel.

[@kartiksagar4209]

Truly Simple And Perfect

[@mahardikagagarin]

Thank you very much, im beginner in excel and i think its take a lot time to insert 1-2-3-4-5 in cell😁

[@ExceltoExcelE]

You are welcome! I have recently created a couple of videos for the new Excel Users, I would recommend you to go through those session. All the best.

[@augustchiropractic]

Would =(selecting the cell above)+1 work just well and be even more adaptable?

[@ExceltoExcelE]

That's one way of doing it

[@atiqrahmanlodhi4709]

How i add 1 -10 in.one column A1 and 11-20 in.column B1 and 20-30 in.coulmn C1. Auto

[@alexskieyt1790]

how to fix my excel when i select 2 rows for number example 1-10 when i select 1 and 2 row all rows are going number 1 how to fix it sir?

[@ExceltoExcelE]

Thanks for the question but unfortunately I really could not get the question, if you could please help explain?

[@tapankumar8984]

Nice video. If we use formula =ROW() from cell A4 (having sl.no. 1), how to dao it

[@robh.1212]

I want excel to assign a unique number to each row and i want that number to NOT change if I sort my table or if I delete a row. In other words if I have 15 rows and I enter a 16th row I want Excel to auto name it serial number 16 and that serial number will stay with that row no matter if other rows are added or deleted and no mater how I sort those rows. How can I do that?

[@schweitzersonbey1279]

This formula it cannot work in my computer.so how should I solved this problem

[@HolyFacts]

THANK YOU AND SUBSCRIBED !!

[@ExceltoExcelE]

Lovely... Thanks alot for watching the video and sharing your valuable comments here. And of course a very welcome subscribed additions. Have a nice day.

[@justusoyieko9867]

This was really helpful. Thanks!

[@ExceltoExcelE]

awesome, Thank you very much for the note, I am so happy that it helped you. Please stay in touch with my channel for more such videos.

[@kingxfx]

THANKS, WORKED FOR ME

[@sarahrose4179]

Very helpful, thank you

[@ExceltoExcelE]

Thank you Sarah for watching the video and sharing your thoughts. Please stay in touch for more such videos and tutorials on my channel.

[@glenntalisic6299]

Hi sir let me ask how can I increase the data in a row for example 0.451 to 451.000? Do you have any idea on how to do it thank you..

[@aminovitchmad4520]

Thank you for the tip
I actually developed it more after that

[@ExceltoExcelE]

Wow, that's cool. Thanks for the note and watching the video. Please stay in touch for more such videos on my channel.

[@SouthDublinPaintingRathfarnham]

That worked, thanks so much.

[@ExceltoExcelE]

Excellent, thanks for the note and watching the video

[@jamgutz]

Hi , i am seriousl;y new with excel .. i just wonder what he clicked after he typed in DATA , that all selected has DATA on it aswell ? ty !

[@brianinnsawan163]

CTRL+ Enter instead of just Enter. CTRL + Enter will fill in all highlighted cells with the data you just typed in the active cell

[@jaishalba8519]

What if you start at A3 but want to number it 1 and so on?

[@kavyaracharya9068]

=ROW(A1) enter and drag

[@6680724]

@@kavyaracharya9068 I love you ❤️

[@rohiniwalunj9845]

And when we delete the between rows , the sequence changes. It s not working

[@scott_hanna]

If you enter “=row()-1” (without the quotations) it will work for you. You can change “-1” to whatever you need it do be to make up the difference of where the actual list starts verses the row number

[@akhonankokhelindlela381]

​@@kavyaracharya9068 I am tarting at A3487 and i want it to be 3470 and automatically continue from there

[@Phoenixspin]

This is magic!

[@ExceltoExcelE]

Thanks for watching the video and providing feedback. Stay in touch for more such videos.

[@gayathrir8973]

Excellent trick. But its not working when i have a header. Could you please guide me on how it works when i have a header?

[@ismailrahman8399]

For counting from second row, use
Row( )-1

[@greyraiz1301]

Thank you soo much you just saved me

[@ExceltoExcelE]

Thanks for the note and watching the video. Please stay in touch for more such videos on my channel

[@yasirbakshi005]

Hi,
What if have to start from a random no. say 1800 then wt vl be the formula? Thx

[@Funkafella01]

If you start at number 1800 hover over the bottom right corner of the cell, a cross will appear. Next hold down the control button( will turn to small + sign) then just drag down. Hope that helped.

[@bettykurian200]

@@Funkafella01 thank you so much 🙏

[@shanesalmon3379]

Thank you very much!!

[@ExceltoExcelE]

Thanks for the note and sharing your thoughts. Please stay in touch for more such videos and tutorials on my channel.

[@GiDi22H]

Well done. Thank you

[@ExceltoExcelE]

Thanks for watching! and sharing your feedback with me.

[@mirahfilms]

Thanks a wonderful tutor

[@ExceltoExcelE]

Thank you for the note and watching the video. Please stay in touch for more such videos on my channel.

[@mehaktanwar3679]

Thanks a lot sir for a help me this topic to clear how to set a row coloum of a row in ms excel thank you so much

[@ExceltoExcelE]

Happy to help, Thanks for sharing comments, please don't forget to subscribe to stay in touch for more such videos

[@tommyharris5817]

@@ExceltoExcelE Please get off YT as your videos are useless and pathetic!

[@kanchanm6351]

It's useful 😃 thank you

[@ExceltoExcelE]

Fantastic, I am glad you could benefit from the video. Thanks for the note and sharing your feedback.

[@harshh62]

Thank you so much!

[@ExceltoExcelE]

Thank you ineeded for watching the video. pls stay in touch for more such videos on my channel

[@froufou100]

thank you but I have a header row at number 1 for my tables my number 1 start at row 2 but yet labels it as number 2, I need it to be number 1, how to get around this for this newbie :)?

[@HA-nr6fs]

I tried formula =Row(A1) in cell A2... seemed to work... in case you are still wondering about that 🤷🏼‍♀️

[@bymars7613]

@@HA-nr6fs thank you so mucchhh

[@mulaparthibrahmaji1995]

It's working

[@azeezakintonde430]

Try =ROW()-1

[@lobstertts8274]

How come when i drag it down, the number stay the same? What went wrong?

[@ExceltoExcelE]

Please remove the $ sing from the syntax

[@rgburritoes959]

What if you want to count down starting at 3700

[@jamesperry1602]

TᕼᗩᑎK YOᑌ - _that was a cool trick._

[@ExceltoExcelE]

Thanks alot for the feedback mate.

[@kirtimishra3117]

@@ExceltoExcelE pp

[@igxniisan6996]

@@kirtimishra3117 you don't have a pp

[@mce8183]

Good morning how do i automate 2023-001 and ends when 2024 starts?

[@danwasser6432]

This doesn't seem to work if I were to add a row. If there a way to use this function with a twist?

[@JayGee6996]

I am currently trying to work out a better way to do this, but the solution I have at the moment is to find an empty cell and add this code =COUNTIF(A2:A1001,"*") This looks in column A and counts how many rows have information in them. Then I type this code in the first cell where I want the number list to start =SEQUENCE($M$1,1,1,1) You will need to change M and the first number 1 to whichever cell you put the countif code in, so if you put the countif code in F6, you'd change it to =SEQUENCE($F$6,1,1,1) The two $'s are to lock the code to that cell. You may already know some of this but I thought I'd explain it in case you haven't come across it. This code also keeps cells blank when not in use but it doesn't shift the number down/lock it to the row so you have to be careful adding rows in the middle of a dataset as it moves the ID which can be an issue depending what you are using it for.

[@JayGee6996]

=SEQUENCE(COUNTA(A2:A1000)) This is a much more elegant solution that does the same as my first post, it will count how many entries there are in Column A (for 1000 rows, but you can change this number to whatever you want) and then it will create a sequence wherever it sees an entry in Column A. This does create the same issue where it will shift down the IDs/numbers when you create a new row in the middle of a dataset. If you simply add data at the bottom of the table, it will just keep giving it an ID/number.
You can also write text before the Sequence code to add text, e.g. ="No. "&SEQUENCE(COUNTA(A2:A1000)) would make a list that looks like No. 1 No. 2 No.3 etc..

[@md.ehteshamuddinkhan9741]

Thank you

[@briankiptoo8228]

....a really big help...thumbs up👍👍👍👍👍👍👍👍

[@ExceltoExcelE]

Glad to hear that! Thanks alot for sharing feedback.

[@katherine4386]

When I do this it just repeats the numbers 1 2 3 1 2 3 1 2 3

[@user-lk8qr8rt5c]

thank you so much

[@ExceltoExcelE]

Thank you for watching the video and sharing your valuable comments here.

[@soundtech7181]

thanks, you help me

[@ExceltoExcelE]

Happy to help

[@lydethful]

Video sound is very low, almost inaudible.

[@arihanthukkire5224]

Thank u so much Sir 😊

[@ExceltoExcelE]

I am so happy that you found it useful. Thanks alot for sharing your feedback here. All the best.

[@YNP777]

Thanks dear bro.

[@ExceltoExcelE]

So nice of you, thanks for your comments, please dont forget to subscribe the channel for more such videos.

[@borneo_kid94]

Thank you sir

[@ExceltoExcelE]

So nice of you

[@doniyorartikov8307]

thanks a million

[@ExceltoExcelE]

Thank you for watching the video and sharing your valuable comments here

[@guptapradeep628]

Same formula for Kg in side automatic

[@6680724]

It will not work if there are heads for table because it will start from number 2 💔

[@scott_hanna]

If you enter “=row()-1” (without the quotations) it will work for you. You can change “-1” to whatever you need it do be to make up the difference of where the actual list starts verses the row number.
If that doesn’t make sense, let me know and I’ll try to explain it better.

[@kingxfx]

@@scott_hanna saved me a lot of work. Thanks

[@biniamyesh5625]

good job

[@ExceltoExcelE]

Thank you Biniam for watching the video and sharing nice comments. please stay in touch for more such videos on my channel.

[@gayathrir8973]

got what i wanted from the comment
thank you

[@ExceltoExcelE]

Thanks for the note Gayathri, I am glad that you could benefit. Please stay in touch for more such videos on my channel and don't forget to subscribe.

[@Trendingnews790]

Thanks 👍

[@ExceltoExcelE]

Thank you for the note

[@Knowledge748vibes]

This is not working in google sheets

[@aishikydatta7268]

Thanku helped a lot

[@ExceltoExcelE]

So glad to hear that

[@antiquescentral]

Why is the into 15 seconds long?

[@ExceltoExcelE]

Thanks for the note and observation, I will make sure to avoid such unnecessary introductory minutes to save everyone's time.

[@samuelchannel4737]

Interesting. ..

[@ExceltoExcelE]

Glad you think so!

[@Pian0Tears]

Thankfully

[@ExceltoExcelE]

Thank you

[@SouthDublinPaintingRathfarnham]

Thanks

[@ExceltoExcelE]

Thank you for watching the video and sharing your valuable comments here.

[@loopfreestyler]

doesnt work if you hide or filter

[@ConstantinTG]

th-cam.com/video/yM-D8c103fU/w-d-xo.html&ab_channel=RimantasDekaminavi%C4%8Dius

[@riteshrt4ss56parmar6]

excel me aisa koi tarika he , jaise ki kisi coulam me 123456 etc serise likhi ho ,or hum 2 number ko delete kar de to automatic 3 number serise 2 number ki jagh se shuru ho jaye, exam 13456

[@herrylahamid4351]

the audio is really low for some reason, very hard to hear you

[@ExceltoExcelE]

Thanks for the note Herry, I apologize for the inconvenience. Very well noted for future videos. I appreciate you watching the video and sharing your valuable comments with me.

[@fathimafarha8217]

Tysm

[@ExceltoExcelE]

Thank you so much Fathima for watching the video and sharing your feedback.

[@justgagsoyolo9323]

he is in good mood

[@ExceltoExcelE]

😍

[@user-xf8vl5lk8w]

Please FIX the LOW sound. Thank you

[@ExceltoExcelE]

Thanks for the note. Will watch out for it going forward.

[@sudhandas7268]

Super

[@ExceltoExcelE]

Many thanks Sudan.

[@tule1726]

Pleplease please help me

[@ExceltoExcelE]

How can I help you?

[@mickbryan7716]

no volume

[@ExceltoExcelE]

Point taken, will be careful in future.

[@lahiruchathuranga8448]

thanx

[@ExceltoExcelE]

Thanks for watching the video and sharing your valuable comments here, please stay in touch for more such videos on my channel.

[@lahiruchathuranga8448]

@@ExceltoExcelE ok, sure ❤️

[@justgagsoyolo9323]

genius

[@ExceltoExcelE]

🙏

[@rohiniwalunj9845]

Start with A 4 cell

[@ExceltoExcelE]

😊

[@Nawfalahmad]

everything is fine but your voice is so slow

[@ExceltoExcelE]

Thanks alot for the note and watching the video. I will make sure it doesn't happen in future videos. Please stay in touch for more such videos on my channel.

[@rosiefernandez206]

Your volume is very low.

[@ExceltoExcelE]

Thanks alot for the note, I will be careful about it in future videos.

[@specialized41]

Intro audio perfect, you voice audio too low..... Fix in the next video.

[@ExceltoExcelE]

Very well noted, thanks for the note and watching the video. Please stay in touch for more on my channel. Have a nice day

[@averagedudeusa9722]

dude its hard to hear you. Please remake this video with louder volume.

[@tyreseswipey6499]

You need to fix your ears cause it’s loud and clear

[@averagedudeusa9722]

​@@tyreseswipey6499 lol most retarded comment of the year. congrats. just fix it. be a professional and fix the crap audio. if you don't fix it you will continue to be an amateur. just trying to give you good advice. take it but I know you will leave it and remain amateur.

[@averagedudeusa9722]

@@tyreseswipey6499 loud and clear to people with big ears. lol

[@FelixPfaltermann]

=ROW() definitely does nothing. This must be outdated.

[@ExceltoExcelE]

It is not outdated, It shows you the row number. I just tried it again and works well.

[@IAMAQT711]

voice to low

[@ExceltoExcelE]

Thanks for the note, I will be mindful about it in future. Stay tuned for more videos and content.

[@gbonsky1]

audio is very weak

[@ExceltoExcelE]

Noted mate, will take care of it in future videos

[@Nnatty1000]

Music loud but your voice could nearly be heard. Smh

[@ExceltoExcelE]

Thanks for the note and point taken for future videos.

[@MrXizelX]

Music volume = 9000
Voice volume = 1

[@ExceltoExcelE]

I believe that's a fair expression of your experience. I can imagine how frustrating it is. First of all please accept my sincere apologies for the inconvenience it has caused. Secondly I confirm that going forward I take this as a lesson learned and will improve the balance. Thanks again for visiting my channel, watching the video and most importantly for sharing your experience. It's helps me to improve.

[@ilmmum]

lolz

[@martinherrera9606]

I can't her anything!

[@ExceltoExcelE]

Thanks alot for watching the video and sharing your valuable comments here. I will make sure that I take care of audio going forward. Have a good one!

[@tommyharris5817]

Why the stupid music?

[@ExceltoExcelE]

Will be definitely mindful about it going forward. Thanks alot for your interest in the channel and more importantly thanks alot for your valuable feedback. Much appreciated.

[@UwU_UwU_69]

Thank you

[@ExceltoExcelE]

Thank you for watching the video and sharing your thoughts.

[@nyeinsuhlaing8747]

Thanks

[@ExceltoExcelE]

Thank you indeed for sharing feedback with me. Much appreciated.

[@smtboystkt6586]

Thanks sir

[@ExceltoExcelE]

Thank you ineeded for watching the video. have a nice day!

[@hapeibren]

Thank you

[@ExceltoExcelE]

Thank you indeed for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel.

[@tazkir90]

Thanks

[@ExceltoExcelE]

Thank you for watching the video and providing feedback. Stay tuned for more such videos ☺️