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.
Пікірлер: 201
Thanks!
@ExceltoExcelE
11 күн бұрын
@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.
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.
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.
Please can u do that with calculations. For example A1 + B1 =C1 can this formula work automatically without the stress of dragging.
How do I increase numbers by a percent amount already in the spreadsheet
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!
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.
Truly Simple And Perfect
Thanks for this simple teaching.
@ExceltoExcelE
Жыл бұрын
Glad it was helpful! Thank you for your comment and for watching the video
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
2 жыл бұрын
Thanks a million Scott for sharing the trick.
@dominicbacaling8606
Жыл бұрын
THANKS!
@_crescent_12_-
11 ай бұрын
thank you!
@bla8358
11 ай бұрын
Thankss❤
@mlltbmrsll
6 ай бұрын
Thank you very much! ☺
Thanks ❤ gratefulness to KZread and this video creator☺️
@ExceltoExcelE
Жыл бұрын
❤️❤️❤️ Thanks for watching the video and sharing your valuable comments here. Stay blessed.
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
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.
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.
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.
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
2 жыл бұрын
Thanks for the question but unfortunately I really could not get the question, if you could please help explain?
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
Would =(selecting the cell above)+1 work just well and be even more adaptable?
@ExceltoExcelE
11 ай бұрын
That's one way of doing it
What if you start at A3 but want to number it 1 and so on?
@kavyaracharya9068
2 жыл бұрын
=ROW(A1) enter and drag
@6680724
2 жыл бұрын
@@kavyaracharya9068 I love you ❤️
@rohiniwalunj9845
2 жыл бұрын
And when we delete the between rows , the sequence changes. It s not working
@scott_hanna
2 жыл бұрын
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
Thank you for the tip I actually developed it more after that
@ExceltoExcelE
9 ай бұрын
Wow, that's cool. Thanks for the note and watching the video. Please stay in touch for more such videos on my channel.
THANKS, WORKED FOR ME
THANK YOU AND SUBSCRIBED !!
@ExceltoExcelE
2 жыл бұрын
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.
How i add 1 -10 in.one column A1 and 11-20 in.column B1 and 20-30 in.coulmn C1. Auto
!!!!!!!!!!!!!!!!!!!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????
That worked, thanks so much.
@ExceltoExcelE
Жыл бұрын
Excellent, thanks for the note and watching the video
Hi, What if have to start from a random no. say 1800 then wt vl be the formula? Thx
@Funkafella01
3 жыл бұрын
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
2 жыл бұрын
@@Funkafella01 thank you so much 🙏
Nice video. If we use formula =ROW() from cell A4 (having sl.no. 1), how to dao it
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..
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
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
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
3 жыл бұрын
Happy to help, Thanks for sharing comments, please don't forget to subscribe to stay in touch for more such videos
@tommyharris5817
2 жыл бұрын
@@ExceltoExcelE Please get off YT as your videos are useless and pathetic!
Well done. Thank you
@ExceltoExcelE
Жыл бұрын
Thanks for watching! and sharing your feedback with me.
This is magic!
@ExceltoExcelE
2 жыл бұрын
Thanks for watching the video and providing feedback. Stay in touch for more such videos.
This was really helpful. Thanks!
@ExceltoExcelE
2 ай бұрын
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.
TᕼᗩᑎK YOᑌ - _that was a cool trick._
@ExceltoExcelE
4 жыл бұрын
Thanks alot for the feedback mate.
@kirtimishra3117
3 жыл бұрын
@@ExceltoExcelE pp
@igxniisan6996
2 жыл бұрын
@@kirtimishra3117 you don't have a pp
This formula it cannot work in my computer.so how should I solved this problem
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?
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.
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.
Thank you so much!
@ExceltoExcelE
Жыл бұрын
Thank you ineeded for watching the video. pls stay in touch for more such videos on my channel
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
3 жыл бұрын
I tried formula =Row(A1) in cell A2... seemed to work... in case you are still wondering about that 🤷🏼♀️
@bymars7613
2 жыл бұрын
@@HA-nr6fs thank you so mucchhh
@mulaparthibrahmaji1995
2 жыл бұрын
It's working
@azeezakintonde430
Жыл бұрын
Try =ROW()-1
Thanks a wonderful tutor
@ExceltoExcelE
3 ай бұрын
Thank you for the note and watching the video. Please stay in touch for more such videos on my channel.
Thank you
It will not work if there are heads for table because it will start from number 2 💔
@scott_hanna
2 жыл бұрын
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
Same formula for Kg in side automatic
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.
What if you want to count down starting at 3700
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.
Thanks dear bro.
@ExceltoExcelE
2 жыл бұрын
So nice of you, thanks for your comments, please dont forget to subscribe the channel for more such videos.
It's useful 😃 thank you
@ExceltoExcelE
3 ай бұрын
Fantastic, I am glad you could benefit from the video. Thanks for the note and sharing your feedback.
Video sound is very low, almost inaudible.
Good morning how do i automate 2023-001 and ends when 2024 starts?
Thanks 👍
@ExceltoExcelE
7 ай бұрын
Thank you for the note
thank you so much
@ExceltoExcelE
5 ай бұрын
Thank you for watching the video and sharing your valuable comments here.
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..
When I do this it just repeats the numbers 1 2 3 1 2 3 1 2 3
Why is the into 15 seconds long?
@ExceltoExcelE
3 жыл бұрын
Thanks for the note and observation, I will make sure to avoid such unnecessary introductory minutes to save everyone's time.
Thank you sir
@ExceltoExcelE
8 ай бұрын
So nice of you
Tysm
@ExceltoExcelE
Жыл бұрын
Thank you so much Fathima for watching the video and sharing your feedback.
....a really big help...thumbs up👍👍👍👍👍👍👍👍
@ExceltoExcelE
Ай бұрын
Glad to hear that! Thanks alot for sharing feedback.
thanks, you help me
@ExceltoExcelE
4 ай бұрын
Happy to help
How come when i drag it down, the number stay the same? What went wrong?
@ExceltoExcelE
11 ай бұрын
Please remove the $ sing from the syntax
Thankfully
@ExceltoExcelE
9 ай бұрын
Thank you
good job
@ExceltoExcelE
2 жыл бұрын
Thank you Biniam for watching the video and sharing nice comments. please stay in touch for more such videos on my channel.
Interesting. ..
@ExceltoExcelE
4 жыл бұрын
Glad you think so!
Thanks
@ExceltoExcelE
Жыл бұрын
Thank you for watching the video and sharing your valuable comments here.
thanks a million
@ExceltoExcelE
8 ай бұрын
Thank you for watching the video and sharing your valuable comments here
Thanku helped a lot
@ExceltoExcelE
Жыл бұрын
So glad to hear that
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.
This is not working in google sheets
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
Please FIX the LOW sound. Thank you
@ExceltoExcelE
Жыл бұрын
Thanks for the note. Will watch out for it going forward.
doesnt work if you hide or filter
@ConstantinTG
2 жыл бұрын
kzread.info/dash/bejne/q4FhppqcYZOZlrg.html&ab_channel=RimantasDekaminavi%C4%8Dius
he is in good mood
@ExceltoExcelE
2 жыл бұрын
😍
thanx
@ExceltoExcelE
2 жыл бұрын
Thanks for watching the video and sharing your valuable comments here, please stay in touch for more such videos on my channel.
@lahiruchathuranga8448
2 жыл бұрын
@@ExceltoExcelE ok, sure ❤️
Super
@ExceltoExcelE
2 жыл бұрын
Many thanks Sudan.
everything is fine but your voice is so slow
@ExceltoExcelE
2 жыл бұрын
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.
Start with A 4 cell
@ExceltoExcelE
2 жыл бұрын
😊
no volume
@ExceltoExcelE
2 жыл бұрын
Point taken, will be careful in future.
Your volume is very low.
@ExceltoExcelE
2 жыл бұрын
Thanks alot for the note, I will be careful about it in future videos.
dude its hard to hear you. Please remake this video with louder volume.
@tyreseswipey6499
7 ай бұрын
You need to fix your ears cause it’s loud and clear
@averagedudeusa9722
7 ай бұрын
@@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
7 ай бұрын
@@tyreseswipey6499 loud and clear to people with big ears. lol
genius
@ExceltoExcelE
2 жыл бұрын
🙏
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
=ROW() definitely does nothing. This must be outdated.
@ExceltoExcelE
3 жыл бұрын
It is not outdated, It shows you the row number. I just tried it again and works well.
Pleplease please help me
@ExceltoExcelE
2 жыл бұрын
How can I help you?
voice to low
@ExceltoExcelE
3 жыл бұрын
Thanks for the note, I will be mindful about it in future. Stay tuned for more videos and content.
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
4 ай бұрын
lolz
Music loud but your voice could nearly be heard. Smh
@ExceltoExcelE
Жыл бұрын
Thanks for the note and point taken for future videos.
audio is very weak
@ExceltoExcelE
5 ай бұрын
Noted mate, will take care of it in future videos
Why the stupid music?
@ExceltoExcelE
2 жыл бұрын
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.
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!
Thank you
@ExceltoExcelE
3 ай бұрын
Thank you for watching the video and sharing your thoughts.
Thanks sir
@ExceltoExcelE
Жыл бұрын
Thank you ineeded for watching the video. have a nice day!
Thanks
@ExceltoExcelE
2 жыл бұрын
Thank you indeed for sharing feedback with me. Much appreciated.
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.
Thanks
@ExceltoExcelE
2 жыл бұрын
Thank you for watching the video and providing feedback. Stay tuned for more such videos ☺️