Serial number auto update in MS Excel

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Follow me
Join Telegram - t.me/bdscomputer
Facebook - / bdscomputergarkha
Instagram - / bds_computer1
RUclips - / @bdscomputer
Email Id - [e-mail]
[e-mail]
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
BDS Computer
#BDSComputer
Thanks for taking the time to watch this tutorial on Compute! I hope you found it informative and helpful. If you enjoyed this video and found it useful, please consider giving it a thumbs up and subscribing to my channel for more great content like this.
Also, if you know anyone who might benefit from this tutorial, please feel free to share it with them. Your support is invaluable and helps me to create more high-quality content in the future.
Thanks again for watching, and I look forward to seeing you in the next video!

[@piyushyadav9272]

sahista ne bade ahisita se samjhaya 💕

[@bdscomputer]

😂😂

[@sajjadarts7286]

😂

[@Drivegamerz1]

He Prabhu aap ke charan kaha hai......😂

[@omgargoswami6397]

Pichware m

[@azharuddin652]

Accha .number dedo

[@digitalaayam2503]

Nice way to convey excel concepts

[@a.4.atul_]

Sahista ji ap aise hi smjaya kro bahut acha samjh aya 🙂

[@codingacademy5271]

hum to without formula ke kardete direct drag karke 😂

[@sakshamtyagi3781]

Bhai tum samjha nhi duabra same galti Hui tuo khud automatically sahi kardega hum drag del ki zarurat nhi baar baar

[@INSAAN-et5dh]

​@@sakshamtyagi3781hum phele sare delete karenge phir drag karenge 😎

[@mr_singh111]

Row Insert pe nahi chale ga😢

[@TheCommentorHeist]

100000 entries ka kya karoge, naukari se nikale jaoge 🤣🤣🤣

[@deepakkk2360]

Are automatically karne k liye h..

[@Sachha.Raasta]

Shahista is bequtiful❤

[@itz_Abhi422]

Excel ko muskil bnana ka liya bhout Dhanyavaad Gadhi 1 likh kar direct Khich lati

[@bdscomputer]

Acha agar koi row bich se delete kaiya jaye to kya wo sr number update ho jay ga agar drag kiya huaa sr ho to???

[@rajking3535]

I like your confidence level..all are facts and the way you representing everyone wants to listen..keep going...❤❤❤🎉

[@ravigupta-su5qc]

I appreciate 🎉 for this excel formula

[@LaxmanKumar-fu4ko]

Aap asa vidio banate hi rhia bhai thank you

[@salamiishtiyaque2850]

Wao
Nice nice ❤

[@shridharbk91]

This is really useful information

[@twistttcreater487]

Awesome thanks sir

[@babyanikaofficial]

*Men of culture, we met again 🗿*
_Jo tum soch rahe ho, wohi mai soch raha hu 🥂_

[@PradeepKumar-cn7ed]

thanks for making understand us 😊

[@aksiddiqui3914]

Bahut badya

[@muntazirify]

Shaista is fantastic ❤

[@Dilwarc]

Great 💯👏👍👍

[@bdscomputer]

Thanks

[@upscaspirantsmotivation205]

Data entry ki job karna h sir ko. Sa course karu

[@kishorchauhan.official]

Wah uncle wah

[@aniketankush218]

Superb!

[@bdscomputer]

Thank you

[@user-ft5ib9ef1m]

Wow Great info 🤩👌👌!!
Love and thanks from Pakistan 🇵🇰

[@monikachhugani6003]

Thanks it's very helpful

[@imranbaxi3233]

Really cool 👍

[@adrenalinerush2009]

Saaabbbbas bitiya❤😅

[@Amit-oh9se]

It's good but I've an easy way that I learnt in my computer classes that is
1~ write 1,2,3
2~ select these and just drag no need to even remember that formula which is used in this video or work
Thnks

[@user-sp9ux3pr1e]

Zabardast ❤

[@rajivsaini8201]

It's helpful.. thanks

[@Bikramsgvlog]

Thanks

[@lakhikant09]

Sir use dynamic serial number bolte hein.
Explanation of =ROW()-1
1. =ROW() se current row no aata hai (=column() se column number)
2. =ROW()-1 matlab current row joki A2 tha to usko 1 lane ke liye current row(2) - 1 to hua 1.(isse current cell ki value 1 ho gyi) Jisse aapka serial number 1 se start hoga. Aur aage aap dynamic sl no bna sakte ho.

[@nishantsharma9147]

Kash inhone ye video mein bataya hota toh 😂😂😂😂
I was about to comment the same.
At least someone took the initiative of being logical rather than cramming 😅

[@RJprajapatiVishnu]

All select krne ke bad ... Alt + E S Ipress kr ke enter button pr clik kr de .... Bilkul aasan

[@priyanka6649]

How?

[@RJprajapatiVishnu]

@@priyanka6649 simple

[@qadirbeg3551]

Very good 👍 gril weldan 😮❤❤

[@muhammadayub7943]

Agar add karna ho tu

[@jayasreeframes]

Thank you 👏

[@shaikhakbarkhan4981]

Tankyou sahista❤❤❤❤❤❤❤❤❤❤❤

[@tiyan266]

Very helpfull thank q

[@SAMMY_777_FF]

Just use =sequence (number of serial number )
Easy peasy

[@AnilKale]

I face this problem every time.... here is solution 🎉

[@bdscomputer]

Thank you ❤️

[@AnilKale]

@@bdscomputer
Keep posting indepth ideas, tricks and teaching
Everything is super useful.
Beginner cannot understand until they face the situation

[@swadhindas2674]

Shaista 😊

[@ishwarkodape4706]

Very good 👍

[@haridhanrabha2645]

I use =row(A1) works fine

[@user-od7ow7bl3y]

Shaista buht cute he❤❤ love from Pakistan 🇵🇰

[@Thukai-Operater]

😂😂

[@alltypeshorts.3114]

Excel me aasan tarika bhi hota hai

[@sagarudnur9812]

Sahista is cute 🥰

[@Kaleshwardas11]

1, ko select karke control ko press kiye hue neeche drag karke bhi aa jayega ya 1,2 select kar drag bhi kar sakte hai sir... Thank u sir for teaching us by formula

[@Vlogsofshubh]

Shi kha apne itna long formula lgane ki jrurat hi nhi he sirf 1 or 2 vali scale dono ko drag krke down krte jao jha tk jana ho

[@mayurigarg7457]

Bt agr apne notice kiya ho baad m jb usne row delete kri toh serial no. Automatically update ho gya...
Agr hum normal krke drag krnege toh automatically update nhi hgi ..haar baar khud s krni pdegi

[@Vlogsofshubh]

@@mayurigarg7457 haji ye to shi bola apne mene sirf drag krke numerical counting kr skte h us liye reply diya tha mayuri ji

[@RavinderSinghDuhan]

Bilkul

[@KiyaniPlateOfFlavour]

Its only applicable when your data starts from row 1 but when u start from row 7 or 10 etc after heading it will not work

[@shivangrathore]

Just do -7 or -10 for that case, easy 🤷

[@mack11192]

​@@shivangrathorewhat if there will be a gap between rows

[@riturajchauhan1440]

=Row( )-Row($A$2)
try this
A means collum no
2 means row no.

[@factkichuski]

​Aisa excel mai hota hich nahi hai sare functions excel mai whole column ya row ke har ak cell mai apply hota hai drag karte samay yadi beech mai row ka gap bhi hai to us gap ke baad fir se row number dekhkar function fir se lagana hoga. 🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐

[@TheUnstoppableShayar]

bro this formula shows row number. So if your want your 10th row to be noted as serial no 1 then just type =row()-9

[@Akbuyers]

Aap ka class mei ham ko jane ka man kar raha hai. Sikh na hai ham ko bhi. Men will be men

[@FarmingWithAsifBashir]

Superb 👌❤

[@RahulSharma-Shree2021]

Too good

[@hearttouchingshayar]

isase achha 1 2 likh kar drag kardo jaldi ho jayega ya jaha se badla ho wahi ke upar do row select kar lijiye aur drag kar dijiye... that's it

[@MrRizwan048500]

Helpful

[@bimlendumishra1346]

ye to us row ko count krta h jnha pr h. yadi h d7 pr ye formula lgate hn to ismein thora changing krna prtah. but ek fourmula jo knhi pe lga skte hn.

[@santasharma2461]

Very cute Sahista

[@farhanaazqureshi9205]

Waaooo 👍👍👍

[@PawanKumar-nl6wh]

Thank sir

[@chandankumarofficial8207]

अरे ये राधिका औऱ सपना से हिट है, love u बेबी यार 😅

[@gamingloverromeo1266]

I like sahista

[@ArvindKumar-fu3zy]

Sahista: Hello Mahila helpline
😂

[@ranjanjena740]

​@@ArvindKumar-fu3zy😂

[@mohammadzeeshan992]

Very impressive. Keep it up.

[@bijaytanty8434]

Good

[@SurajVerma-op2dq]

Thanks You Sir , Awesome Trick 🙏

[@princechaudhary7807]

Good 👍

[@arjunms8531]

Best video
#parthai2023

[@mdshahidhussain8977]

Nice trick

[@farooqkhan308]

achi information hai bohot kaam aaegi mere😅😅

[@harikishanmahaur2571]

This formula is based on excel rows no.
- like we working on row no 22 and use this formula then we get 21 of our working row.

[@yubrajbhatt1204]

Yes I also tried and same happened

[@typingforall]

Good job 👍

[@WanderWild311]

Good one

[@mr.samresh9087]

aapko vhi no likhna hai jis no ke row me aaap ho us se ek kam , ager aap 10th row pe ho to formula hoga =ROW()-9

[@ShivamSingh-dm3he]

Ok thanks

[@subirgayeen9494]

Thank u vaiya. Ye crucial info ye RUclips wale ne nahi bataya tha. Mai idhar ye trick sikh ke computer me try Kiya aur alag alag row pe alag alag no. ata raha 😂 pagal ho raha tha. Ye adha gyan dete hai log. Mai soch raha tha mera pc kharab hai 😢.

[@anjalibs6086]

🎉❤

[@vikramchand7205]

Thx 🙏

[@RajKumar-ko6wr]

Isse bhi easy trick hai

[@kumarlu007]

Wowwwww... Beautiful.... But Row add krne pe ye work kre aisa v formula btayie sahistaa

[@mndaaa8732]

Thanks Saista jeee .. Mai v sikh liya

[@sachinbamniya9410]

Ise ach to pehle column me 1 likhiye bad me column select kijiye after alt + h + f + i + s click kijiye bad me seris likha huaaa asyega usme last me step value likha hoga usme 1 type kijiye stop value me aap jitna chahiye utne number enter karo aur ok karo

[@user-gh2tu9pw2m]

I Love you 😘💓❤

[@limitlessrahull]

Thanks😊

[@bdscomputer]

Welcome 😊

[@layers9019]

Shaista .... Voice😌😌

[@himanchaltandi5221]

Nice

[@bdscomputer]

Very nice

[@rajatsharma3861]

Awesome

[@stanzingyalpo9851]

superb

[@susantadas-0026]

Sahista l love you

[@user-gt6yf6it6c]

Nice wayyy

[@ravipatel9316]

But if someone add the row on top of table, maybe Number can change cause you taken reference of number from row number ruller bar

[@omgargoswami6397]

❤

[@KailashYadav-xy9yx]

Very nice

[@HindiEnglishStory07]

Amazing trick Sir

[@Mr.x0015]

Bahut lengthy hai,1aur 2 ko select kro jab chota +show hoga tab down side drag kro to ho jayega,bahut simple hai aur short bhi

[@abhishekkumre3665]

Super

[@SubhamSingh-go4do]

Saista mujhe achchi lgi... isrf Saista ki wajah se maine video 5-6 baar dekha 😎😎

[@blackcommando1307]

Yes! Cause she is your sister 😂

[@ANANDKUMARPANDEY-xo7we]

Insert column karana ho 1 column chhodkar fir 1 column add karana ho multiple kaise hoga

[@nobody-eu7kd]

Excel or Ms office kaa matlab mouse ko bina touch kiye kaam karo tabhi expeet maane jaoge....

[@mahiesahani143]

Select Row & delete, Select all =row()-1 Enter & dreak all & Done

[@tanmayvarshney9200]

2 ko upper cell+1 kro. Or drag kro toh kuch bhi delete kro result ese hi aata hai serial wise.

[@AdityaSingh-ht2xk]

Fantastic

[@AlokKumar-gj8kr]

Mil Gai shishta😂😂😂😂

[@bdscomputer]

😂😂😂😂

[@majhibabu7336]

Hame to pehle sehi pata tha😂😂😂😂😂

[@boomboomcarpet5967]

Ek no. Sir

[@thepathtoallah9180]

good

[@1234indain]

Sab se best idea doon ctrl Z click kariye automatically ajayega bhai😅

[@cakedesigns_7567]

=row()-1 enter bottom click krenge thank you 😊

[@MyDalveer]

Easy formula= 1+1

[@EagleArtGaming]

😂

[@lalitupadhyay7067]

Row no 1 me auto fill me + ka sign aega to drag kijiye sereal no ajaega

[@MuhammadAfzal-gc1nn]

An XL formula that adds the serial number to the data once should not be added again

[@tsdigitalcreator]

❤❤❤👍🏻👍🏻👍🏻

[@misterankitp]

😮😮😮