How to Insert Serial Number Automatically in Excel

[@Excel10tutorial]

Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/3TTDOu6

[@faustopf-.]

This is exactly what I was looking for and nobody was able to explain or know. Thank you so much!

[@Excel10tutorial]

Glad it helped! Please subscribe and be with us.

[@chrisballen7851]

That was so helpful! Thank you!

[@Excel10tutorial]

So glad! Please subscribe and be with us.

[@rrirs]

Thanks Bro, It worked for me.

[@Excel10tutorial]

You're most welcome! Please subscribe and share.

[@romabash296]

Thanks for sharing this , you helped me 🤝

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@tmusarurwa118]

I have a series of products on different stores how do I make sure all products have the same price in each and every store

[@Excel10tutorial]

Use Vlookup or Index Match or Xlookup function and fetch the price from a single place to each store.

[@Idoko_Ifeanyichukwu]

It is compulsory to convert the cells to table before using the formula? Whatever your answer is, could please explain your reason for your answer. Thank you.

[@Excel10tutorial]

If you convert into table; next time you add data in the next cell it will be included into the table automatically. Once a new row is added to a table it will automatically copy the formula from above cell into the newly added row making the serial number automatic.

[@AjayGupta-r4h]

Can we do it without changing to table ?

[@Excel10tutorial]

kzbin.info/www/bejne/mJ_Fcp6ZepZmd80

[@lavelclaytorsProjectswPurpose]

Omg thank you so much for sharing

[@Excel10tutorial]

Any time!

[@mgsoomro4039]

When I am pressing the f4 key there is another screen open

[@Excel10tutorial]

Then Press and hold FN key and F4

[@mirsonhansey3360]

I don't understand about left keyboard you said, could please tell me?

[@Excel10tutorial]

Please explain.

[@sahibgraphics]

what if i want the auto serial number without making it table ?

[@Excel10tutorial]

Checkout our related video: How To Insert Date and Serial Number Automatically in Excel Using Formula: kzbin.info/www/bejne/hYC9nIV-bZ2DpJY How to Enter Date and Serial Number Automatically When data is entered in excel: kzbin.info/www/bejne/nYqVo3Zjj8dpp80

[@renukharenn8652]

Would this work on the following situation? I have a table which I'd like to be automatically numbered. However I do not want each row to be numbered. What can I do?

[@Excel10tutorial]

Check this one. kzbin.info/www/bejne/mJ_Fcp6ZepZmd80

[@piku8700]

Thanks a lot

[@Excel10tutorial]

Happy to help

[@abdulmoheed2612]

THANK YOU MY DEAR FRIEND

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@taxpayer8253]

If I add row it gets disturbed. Please guide

[@Excel10tutorial]

Yes

[@Aamiranalyst]

That's awesome what exactly I want and exactly I got Again thank you so much

[@Excel10tutorial]

Glad to hear that. Please subscribe and be with us.

[@SavvyOlawale]

👍👍👍 Thanks

[@Excel10tutorial]

You're welcome

[@eddhernandez3084]

Thank you

[@Excel10tutorial]

You're welcome

[@phanusomrat6812]

ขอบคุณมากครับ

[@Excel10tutorial]

You're most welcome

[@shobitadhar4540]

Sir, cannot understand your accent. Please put subtitles in english

[@Excel10tutorial]

It should be there. I'll check.

[@preciousopeyemi1130]

Thanks

[@Excel10tutorial]

You're welcome. Please subscribe.

[@jsbuqs7336]

Thank you

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.