If Excel cannot determine your sequence, it will simply start repeating your selection in the cells following your selection. You can extend your sequence by simply clicking the last few values and repeating this process. If your sequence requires more than two values to establish itself, enter the number of necessary values. Step 1: Enter the first and second values of your sequence into a column. If there is no discernible pattern or sequence in the set of values that you have highlighted, Excel will not be able to automatically complete your values.īegin by opening the Excel file that you want to automatically number. Simply enter the number of values necessary to establish the pattern, then activate Autofill to complete the number of values you require. This is the perfect solution if you are inputting sequential values that follow a pattern. How to Automatically Number Rows in Excel 2010 (Guide with Pictures) Our article continues below with additional information on numbering automatically in Excel, including pictures of these steps. Drag down to select the cells that you wish to number automatically. Click and hold on the fill handle at the bottom-right of the selected cells.Click and hold on the top cell, then drag down to select the second as well.Put the second value in the cell underneath it.Enter the first value into a cell in a column.7 Additional Sources How to Do Automatic Numbering in Excel 2010
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |