How to Number Rows in Excel (The Simplest Way)

How to Number Rows in Excel

This video tutorial offers the simplest way how to number rows in Excel.

Would you like to know more? Keep watching!

Would you rather watch this tutorial? Click the play button below!

The Simplest Way How to Number Rows in Excel

There are more ways how to number rows in Excel. The simplest and at the same time a super-fast one is the one we’re about to talk through right now.

To start with the numbering, we need to fill in the first two rows with the numbers 1 and 2.

How to Number Rows in Excel - fill in the first two rows with the numbers 1 and 2

Then we select these two cells, click on the bottom right-hand corner of the selected area and, holding the left mouse button, drag through all the rows we need to number. Like this.

How to Number Rows in Excel - select these two cells, click on the bottom right-hand corner

This is an ideal way to number several rows at once. But sometimes, there can be way too many rows in the table. And at that point, there comes one of our handy lifehacks.

Let’s undo the changes and have a look at another quick and easy way.

How to Automatically Number All the Rows in Excel

The initial step in which we type the numbers 1 and 2 in the first two rows stays the same. However, in the next step you don’t need to drag the corner down through all the rows – a double-click will do the trick!

double-click

This will automatically number all the rows that contain data, no matter how many of them there are in the table.

This will automatically number all the rows

But this trick works only with rows which hold data values; it doesn’t work with blank rows.

Let’s see what happens if there’s a blank row in the data table.

We’ll use the Undo button here and delete let’s say ‘August’, which will leave the row empty.

How to Number Rows in Excel - Undo button
How to Number Rows in Excel - Delete August

Now we’ll try our trick again, but the blank row stopped the numbering.

How to Number Rows in Excel - the blank row stopped the numbering

So, if you’re planning to use this handy trick, you need to make sure the data table doesn’t contain any blank rows. The easiest way to get rid of a blank row is to remove it.

You can learn all this and more on how to remove blank rows in Excel in the video tutorial by EasyClick Academy in the list below.

All in all, it’ll be always safe to use the good old way of holding and dragging, which will number even the blank rows in the table.

How to Number Rows in Excel - hold and drag
How to Number Rows in Excel - will number even the blank rows in the table

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.