{"id":484,"date":"2011-12-22T16:23:20","date_gmt":"2011-12-22T16:23:20","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=484"},"modified":"2023-12-30T23:13:13","modified_gmt":"2023-12-30T23:13:13","slug":"automatically-numbering-rows","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/automatically-numbering-rows\/","title":{"rendered":"Automatically Numbering Rows"},"content":{"rendered":"<p>Have you ever wanted to automatically number rows of data in Excel?<br \/>\nOne way to do this is by using the Row function.<\/p>\n<p>For example,\u00a0type a heading such as ID into A1 then in A2 type the formula<\/p>\n<p><strong>=Row()-1<\/strong><\/p>\n<p>\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/12\/Autonumbers1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-490\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/12\/Autonumbers1.png\" alt=\"\" width=\"322\" height=\"317\" \/><\/a><\/p>\n<p>In this example suppose you want the numbers to be inserted automatically as you add new rows of data. This can be done\u00a0by\u00a0turning the data into an ExceI Table.<\/p>\n<p>Click <strong>Home<\/strong>, <strong>Format as Table<\/strong>.<\/p>\n<p>Select\u00a0<strong>Table Tools Design<\/strong> then tick <strong>Total Row<\/strong>.<\/p>\n<p>When you insert a new in the Total Row a new ID number will be inserted.<\/p>\n<p>Note:The ID numbers will be updated if you sort, insert or delete rows of data.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever wanted to automatically number rows of data in Excel? One way to do this is by using the Row function. For example,\u00a0type a heading such as ID into A1 then in A2 type the formula =Row()-1 \u00a0 In this example suppose you want the numbers to be inserted automatically as you add [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[149,202,219],"class_list":["post-484","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-dd","tag-excel-hints","tag-excel-tips"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=484"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/484\/revisions"}],"predecessor-version":[{"id":6756,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/484\/revisions\/6756"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}