7 Quick & Easy Ways to Number Rows in Excel

No video

7 Quick & Easy Ways to Number Rows in Excel

Рет қаралды 231,418

Күн бұрын

When working with Excel, there are some small tasks that need to be done quite often. Knowing the ‘right way’ can save you a great deal of time.
One such simple (yet often needed) task is to number the rows of a dataset in Excel (also called the serial numbers in a dataset).
Now if you’re thinking that one of the ways is to simply enter these serial number manually, well - you’re right!
But that’s not the best way to do it.
Imagine having hundreds or thousands of rows for which you need to enter the row number. It would be tedious - and completely unnecessary.
There are many ways to number rows in Excel, and in this video, I am going to share 7 quick and easy ways to numbers rows in Excel.
The following methods to number rows in Excel are covered:
-- 1] Using Fill Handle
-- 2] Using Fill Series
-- 3] Using the ROW Function
-- 4] Using the COUNTA Function
-- 5] Using SUBTOTAL For Filtered Data
-- 6] Creating an Excel Table
-- 7] Adding 1 to the Previous Row Number
Every method has some pros and some shortcomings. I discuss these when I talk about each method.
You can read more about the techniques here: trumpexcel.com...
Let's Connect:
Google+ ► plus.google.co...
Facebook ► / trumpexcel
Twitter ► / trumpexcel
Pinterest ► / trumpexcel
KZfaq Channel ► / trumpexcel
Number rows in Excel, Automatically Number rows in Excel, Insert Row Numbers in Excel, Insert Serial Numbers in Excel #Excel #ExcelTips #ExcelTutorial

Пікірлер: 80

@cadjiton Жыл бұрын

Thank you so much Sumit. =if(isblank formula is great, you always make our life easy,

@trumpexcel Жыл бұрын

Glad you found the video useful 😀

@maitrayeechakraborty5819 3 жыл бұрын

I AM SIMPLY LOVING YOUR VIDEOS. SOOOOO HELPFUL. THANKS TONS

@Smitty_Werbenjaegermanjensen 3 жыл бұрын

You just made my life so much easier I have googled how to do this so many times and kept getting different answers that were right

@bellomuhammadmusawa9497 3 жыл бұрын

I'm glad to come across this video. It was indeed helpful. Thank you so much.

@alucinavecina2925 2 жыл бұрын

Absolutely great video!!! Thank you so much!!!

@MmPwsott 3 жыл бұрын

great! finally found what I was looking for! Very good and clear English!!

@trumpexcel 3 жыл бұрын

Glad you found it useful

@benjaminnoine9246 Жыл бұрын

very helpful. Thanks

@baskarmadhu9264 2 жыл бұрын

THANK YOU SO MUCH

@Mickeymouse88934 2 жыл бұрын

I appreciate this soooo much. THANK YOU!!!

@muneerem8536 Жыл бұрын

SUPER, LOTS OF INFORMATION IN SINGLE VIDEO...

@zipporahmwaura9445 Жыл бұрын

Thank you so much I was really stuck literally. You have been very helpful

@igot_ethics 4 жыл бұрын

Thankyou for this tutorial very helpful

@aland6350 Жыл бұрын

Thank you.

@nickbell6311 Жыл бұрын

Your videos always amazing, especially custom formating clever tips, found it very useful, great job

@lorinlorin4315 4 жыл бұрын

Very nice tutural clear n easy way to understand

@romelmannalon268 Жыл бұрын

Thanks, been a long time did not use numbering in excel

@supplychain4302 10 ай бұрын

Thank you!

@bohemaxxtum 6 жыл бұрын

thank you sir,you are very helpful with your videos.

@bagassyahroni 4 жыл бұрын

Thanks yo. Very helpful, auto subscribe.

@alexrosen8762 6 жыл бұрын

Very good and useful tutorial

@stormin9308 4 жыл бұрын

THANK YOU! I've been looking for an answer to my issue for 3.5 years. I have one special note: I'm numbering a ROSTER that has the party's LAST NAME in Column B and FIRST NAME in Column C. In a number of instances, there are two members of that party but we do NOT repeat the LAST NAME in Column B for aesthetic reason. By inserting a "space" in Column B, the system "thinks" there is text there and assigns a number for the 2nd member of that family. THANK YOU so much as I've been manually numbering for years.

@mohanpal13555 3 жыл бұрын

Really amazing trick

@rajeshbiswakarma7189 4 жыл бұрын

Thank You very much Sir... Your methods helped me a lot.

@vishnurj6207 5 жыл бұрын

thank you. you are doing great work.

@goodearthengineers6828 5 жыл бұрын

Excellent job. Thank you

@switbeee1364 2 жыл бұрын

Thank you. Is there a way you can type the number of rows then stop the rows at that inputed number. EG on H1 type 5 then rows end at A5?

@sathishneralakatte1620 2 жыл бұрын

🙏 beautiful information sir ☺️

@anoopvasudevan509 2 жыл бұрын

Thank you. But in Subtotal when you filtered greater than 50, at the bottom of the tabulation it selected less than 50 valued rows too. How do we avoid it? That is where I am stuck and I noticed it is there for you too.

@chdglode Жыл бұрын

Thanks! How to increase rows with a dot after the number by pulling the handle?

@skum196 2 жыл бұрын

Thank you but in my ms excel + sign does not appear in fill handle and I am unable to use drag function of the pointer.What could be the problem

@chandamishra2323 5 жыл бұрын

Thanks, it was useful.

@alialbayati9368 6 жыл бұрын

Thanks for this tutorial.

@hamzahmi9092 4 жыл бұрын

thanks, really helpfull.

@fenchai4892 6 жыл бұрын

awesome tips!

@maitrayeechakraborty5819 3 жыл бұрын

In count formula how did you lock that B2?

@pranavmanohaur391 Жыл бұрын

EXACTLY

@saidurgabade6262 3 жыл бұрын

Hey I added extra rows and given sno, but it doesn't showing nos at all wt to do?

@sunithabhaskar8426 5 жыл бұрын

Thank you very 5

@planxlsm 6 жыл бұрын

very good !

@rjchua2008 5 жыл бұрын

thanks you so much

@TheShgupta 6 жыл бұрын

Hello Sir, do you have any video only for all the formulas. Please upload that too, I could not find it. Very nice and easy way of teaching. Congratulations

@matthewstysonziwa6990 2 жыл бұрын

when making graphs, my computer doesnt bring graphs on pressing Alt+f1.kindly help

@rajukarunakaran2333 3 жыл бұрын

usefull, ThankU

@sunithabhaskar8426 5 жыл бұрын

Thank you

@sanjayagarwal7243 6 жыл бұрын

Nice sir.Thanks.

@dyalahamadi2327 5 жыл бұрын

Hello , what i have some rows highlighted in specific color and i want to give each color a serial number (for example the white cells will have their own and the yellow ones will be counting aside ) ?

@sebastianbryk3074 4 жыл бұрын

You mister just saved my ass with this video! :D

@alfredeugenelasangue6630 Жыл бұрын

5:41 how to lock said count? Many thanks

@old_is_gold1977 4 жыл бұрын

After a blank space in a row, how do I start the count from number 1. Can you please show some method. Your video is informative. Thank you.

@MuhammadImran-id3mg 6 жыл бұрын

Great findings

@johnssanthu 6 жыл бұрын

Error in Subtotal function If we use filter by keeping any condition if condition true or false unnecessary it is showing the last row.

@excelkingtamil571 6 жыл бұрын

I am facing same problem

@krmotionexcel 5 жыл бұрын

Sir but missing complex numbering system like " EXP/001/18-19" special for invoice numbering........ Please solve.......

@swetaawasthi7036 3 жыл бұрын

Sir, how can we give serial numbers in a single cell before each char (10)

@edwinotieno9189 Жыл бұрын

Shortcut for creating table Press CTRL+T

@sathishkumar-sy2kg 6 жыл бұрын

Hi.. can you tell how to use macro in excel..

@ShawnMoorephoto 4 жыл бұрын

OMG 15 minutes for a simple task

@SnugglyFruit 4 жыл бұрын

what if I want 1,2, and 3 to repeat over and over? like; A - 1 B - 2 C - 3 D - 1 E - 2 F - 3 etc...

@binayakarmacharya1059 5 жыл бұрын

What if, in column A I have data series of 1,2,3,4,5 and next column I need to generate 11,22,33,44,55 without multiply 11 and use paste special method. Automated method?? Thank you.

@ksdnsdkumar1375 4 жыл бұрын

please post your doubt at superuser.com

@Kratoshomes 5 ай бұрын

How to fill number series like 1.2,1.3,1.4 and 1a,1b,1c

@trumpexcel 5 ай бұрын

You can 1.1, 1.2, 1.3 using fill handle. Enter 1.1 in one cell adn 1.2 in cell below, then select both the cells and drag the fill handle down. 1a, 1b, 1c is tricky as fill handle doesn't recognize alphabets the same way