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. Step 3: Check the box to the left of Headings in the Show section of the ribbon. Your row labels should now be visible. 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. 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. 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. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
