{"id":360097,"date":"2021-10-29T18:00:16","date_gmt":"2021-10-29T15:00:16","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-number-rows-in-microsoft-excel\/"},"modified":"2021-10-29T18:00:16","modified_gmt":"2021-10-29T15:00:16","slug":"how-to-number-rows-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-number-rows-in-microsoft-excel\/","title":{"rendered":"#How to Number Rows in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2f00d0ea8ce\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2f00d0ea8ce\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-number-rows-in-microsoft-excel\/#Number_Rows_Using_the_Fill_Handle\" >Number Rows Using the Fill Handle<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-number-rows-in-microsoft-excel\/#Number_Rows_Using_the_ROW_Function\" >Number Rows Using the ROW Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-number-rows-in-microsoft-excel\/#Use_a_Custom_Number_Series\" >Use a Custom Number Series<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Number Rows in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Microsoft Excel provides row headers starting with number 1. But if you have data that you want to number beginning below the first row, these row headers aren\u2019t much help. We\u2019ll show you how to add your own row numbers.<\/p>\n<p>You may want to number rows for an easy way to collaborate and make sure you\u2019re talking about the same data. Or, maybe you want to use a specific sequential <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">series<\/a> for reference numbers throughout your sheet. You can add numbers like this in Excel using the fill handle or a function. Let\u2019s walk through the options.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Number_Rows_Using_the_Fill_Handle\"><\/span>Number Rows Using the Fill Handle<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By using the fill handle, you can create a series of numbers or letters by dragging through cells. The key to using this method is the pattern you begin with and copy.<\/p>\n<p>For example, if you simply want to start numbering with 1 and go in order, you would enter \u201c1\u201d in the first cell and \u201c2\u201d in the cell below it. This establishes a pattern.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756910\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/StartPatternToFill-ExcelNumberRows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Start a fill pattern\" width=\"650\" height=\"234\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, select both cells and drag the fill handle to the subsequent rows. You\u2019ll see a preview as you drag showing the numbers that will populate.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756911\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/PatternToFill-ExcelNumberRows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drag the fill handle to number the rows\" width=\"650\" height=\"253\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you have a break in your data and want to continue the numbering after the break, you can do so with the next pattern in the series.<\/p>\n<p>For instance, you may have rows numbered 1 through 6, a break of three rows, and then want to pick up the numbering with 7 for the rest.<\/p>\n<p>Enter \u201c7\u201d in the cell you want to number and \u201c8\u201d in the cell below. Then select both cells and use the fill handle to drag once again. Excel is smart enough to know your pattern and comply.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756912\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/ContinueFill-ExcelNumberRows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Continue numbering rows\" width=\"650\" height=\"451\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Number_Rows_Using_the_ROW_Function\"><\/span>Number Rows Using the ROW Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another way to number rows is using the ROW function. With it, you can also use the fill handle to drag the formula you enter to the remaining rows.<\/p>\n<p>Select the cell where you want to start numbering. If you want to start with the number 1, you would use the A1 cell reference and enter:<\/p>\n<pre>=ROW(A1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756915\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/RowFunction-ExcelNumberRows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the ROW function in Excel\" width=\"650\" height=\"268\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can then drag the formula to the cells in the rows below. Now if you have a break in your data, like in the example above, you can continue your numbering after the break with this same function.<\/p>\n<p>Go to the cell where you want to pick up the numbering and enter the function with the corresponding cell reference for the number you need. So, if you want to start with number 5, you\u2019d use A5 or if you want to start with number 10, you\u2019d use A10.<\/p>\n<p>For our example, we want to continue with the number 7, so we would enter:<\/p>\n<pre>=ROW(A7)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756916\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/ContinueRowFunction-ExcelNumberRows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Continue number with the ROW function\" width=\"650\" height=\"471\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And again, you can then drag the formula to the remaining cells using the fill handle.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_a_Custom_Number_Series\"><\/span>Use a Custom Number Series<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As mentioned, you can use these methods for numbering rows, but also for reference numbers. Maybe you have product orders, customers, or something similar that you want assign numbers to. For instance, you might want to start numbering as 0001, 0002, and 0003 or 00-001, 00-002, and 00-003.<\/p>\n<p>With the ROW function, you can include the TEXT function to designate the numbering format for the series you want.<\/p>\n<p>As an example, we want to start numbering with 0001. Here is the formula to enter:<\/p>\n<pre>=TEXT(ROW(A1),\"0000\")<\/pre>\n<p>With this formula in the cell, the result would be 0001. The A1 reference assigns a number 1 and the 0000 is the format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756913\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/RowTextFunction-ExcelNumberRows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the TEXT and ROW functions\" width=\"650\" height=\"240\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And like the other methods listed here, you can use that convenient fill handle to copy the formula to the cells in the subsequent rows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756914\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/FillRowTextFunction-ExcelNumberRows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Continue numbering with the TEXT and ROW functions\" width=\"650\" height=\"217\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To continue numbering after a break, just use the corresponding cell reference as described earlier.<\/p>\n<p>If you\u2019re not fond of the way that Excel uses letters as column headers, did you know that you can change the cell reference style? Have a look!<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/756907\/how-to-number-rows-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Number Rows in Microsoft Excel&#8221; Microsoft Excel provides row headers starting with number 1. But if you have data that you want to number beginning below the first row, these row headers aren\u2019t much help. We\u2019ll show you how to add your own row numbers. You may want to number rows for an&#8230;<\/p>\n","protected":false},"author":1,"featured_media":360098,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-360097","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/360097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=360097"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/360097\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/360098"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=360097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=360097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=360097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}