How to Add Row Numbering in Excel 2013

Numbering your rows in Excel is helpful when you need to reference a particular cell either to another person or as part of a formula. So when the labels that typically identify your rows aren’t present, it can make your work a little more difficult.

Or perhaps you need to include an additional column in your spreadsheet where you are numbering a cell in each row of a column.

But instead of typing all of those numbers in yourself, you might be looking for a more efficient way to achieve the desired result.

Our guide below will show you how to do each of these things so that you can add row numbering to your Excel spreadsheet in whatever way you need.

How to Add Row Labels in Excel 2013

The steps in this section assume that you currently don’t see the row labels to the left of your spreadsheet.

Note that this will also assume that you do not see any column letters either. These items are called Headings, and both the row headings and the column headings are controlled with the same setting.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the View tab at the top of the window.

click the view tab

Step 3: Check the box to the left of Headings in the Show section of the ribbon. Your row labels should now be visible.

how to add row headers in excel 2013

If you want to be able to quickly fill a row of numbers with consecutive numbers, then continue to the section below.

How to Fill Rows With Consecutive Numbers in Excel 2013

This section does not deal with the row labels that we added in the section below. Rather this is going to add values to your cells in the form of a numerical sequence that increases by one.

Following the steps in this section will allow you to do this quickly and error-free, which is likely a relief if you had previously done this by manually typing in all these values.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click in the top-most cell where you want to start the row numbering, then type the first number that you want to use for the numbering.

put first number of sequence in top cell

Step 3: Hold down the Ctrl key on your keyboard, click and hold on the bottom-right corner of the cell, then drag down until you have selected the number of cells to which you want to add the consecutive numbers.

Release the mouse button to fill those cells. Note that the number that goes into the bottom-most cell is shown as a small pop-up number slightly below your mouse cursor.

how to add row numbering in excel 2013

Now that you know how to add row numbering in Excel 2013, you can use these steps in the future whenever you have a spreadsheet that needs this type of formatting.

Do you have a large spreadsheet that is difficult to put into a summarized format without a lot of additional work? Find out more about pivot tables and see if that is a tool that can be useful for your Excel activity.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy