Step 1: Type the first number of your series into the first cell where you would like to enter the numbers. This is probably the most effective way to do this, as it is going to help you to create the series of numbers that you are looking for in almost any situation. Method 1 – Using the Ctrl Key on Your Keyboard There is more than one way to do this, so we will show you two different options and you can decide which solution is better for you. The steps in this article will show you how to create a sequence of consecutive numbers in a row or column. How to Numbers Rows Automatically in Excel 2013 (Guide with Pictures) Our tutorial below will show you two different ways to achieve this result.ĭo you want to start color coding cells in your spreadsheets? Then check out our background color Excel article to learn how. You can automatically number rows in Excel by entering the first number of the sequence into a cell, selecting that cell, holding down Ctrl on your keyboard, then clicking and dragging the bottom-right corner of that cell until you have selected all of the cells that you want to fill with numbers from that sequence.įortunately, Excel 2013 has a feature that will automatically fill rows or columns with a series of incrementally increasing numbers. You may have explored different options like the row function, or simply typing your data into all the cells, but there is another way to generate a large number of sequential numbers in an Excel spreadsheet. That’s why it’s so nice that there is a way to generate consecutive numbers in Excel automatically. It’s a common task in Microsoft Excel 2013 to fill a row or column with a series of consecutive numbers.īut doing it manually can be tedious, and there’s always the possibility of a typo that could create problems in the future. Our guide continues below with additional information on how to use the sequence number fill tool in Microsoft Excel, including pictures of these steps. Drag down to the desired cell, then let go.Click and hold the bottom-right corner of the cell.5 More Information on How to Auto Number a Row or a Column in Excel How to Use the Fill Handle to Number Data Automatically in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |