<\/figure>\n\n\n\nLet us say that we want to add numbers to this random table. We will insert one column as column A<\/strong>, and then we will input number 1<\/strong> in cell A2<\/strong>, and number 2<\/strong> in cell A3<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will then drag our pointer to the end of our table. Excel will automatically notice a pattern and will input the other rows:<\/p>\n\n\n\n <\/figure>\n\n\n\nIt is worth mentioning that this works only if you input two numbers, meaning 1 and 2<\/strong>. If you put only number 1<\/strong>, this will not work. Also, if we have a large set of data, and we do not want to drag the numbers, we can hover over the right square that appears at the bottom-right of our selection and click on the plus icon.<\/p>\n\n\n\nExcel is usually great at recognizing all kinds of patterns. For example, if you input 1 and 3 first, Excel will automatically input all the odd numbers in our table:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe can also use the Fill Series<\/strong> option, which gives us a little more control over our data. We will again input number 1<\/strong> in the cell A2<\/strong> and go to Home >> Editing >> Series<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOn a pop-up that appears, we will do the following: choose Columns in series<\/strong>, give a Step value of 1<\/strong> and Stop value of 19<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe downside of this approach is that we need to know the number of our rows.<\/p>\n\n\n\n
Add Row Numbers with Row Formula<\/h2>\n\n\n\n There is another way to add the numbers to a table, and that is with the formula. We will input the following formula now in cell A2<\/strong>:<\/p>\n\n\n\n=ROW(B2)-1<\/code><\/pre>\n\n\n\nFormula ROW<\/strong> returns the number of our row. Since basically, Steven Adams is the first player in our table, we do not want him to be number 2<\/strong>, which is the number of the row he is at. So, we also subtract one number from our original number, to get the result that we want.<\/p>\n\n\n\nWe will click on the plus icon at the bottom right when we hover over cell A1<\/strong>, and then the whole list will be populated:<\/p>\n\n\n\n <\/figure>\n\n\n\nAdd Row Numbers with the COUNTA Function<\/h2>\n\n\n\n Let us now delete a couple of entries in column E<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nIf we want to insert row numbers for column E<\/strong>, we will input the following formula in cell F2<\/strong>:<\/p>\n\n\n\n=IF(ISBLANK(E2),\"\",COUNTA($E$2:E2))<\/code><\/pre>\n\n\n\nThe IF function<\/strong> checks if the cell next to the cell in column E<\/strong> is empty or not. If it\u2019s empty, it returns a blank<\/a>. If not, it gives us the count of all the filled cells till that cell.<\/p>\n\n\n\nWhen we drag this formula till the end, we will have the following results:<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"We are dealing with Excel tables every day. They are one of the most useful things in Excel and can present our valuable…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Add Row Number to an Excel Table<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n