How to Automatically Number Rows for an Excel Spreadsheet

Written by greg lindberg
  • Share
  • Tweet
  • Share
  • Email

The Microsoft Office software package includes applications that allow you to automatically number a specific date. Microsoft Excel does not allow users to number rows, but there is a simple technique to have rows updated. Using the fill handle tool you can drag a selected field of numbered rows and continue the numbered sequence into other rows. This technique for numbering rows can be done the same way for both the 2003 and 2007 version of Excel.

Skill level:

Things you need

  • Microsoft Excel

Show MoreHide


  1. 1

    Open the Microsoft Excel application on your computer. Click on the first cell where you want to establish a numbered pattern.

  2. 2

    Type the beginning of the pattern in the first cell, like a “1.” Click on the next cell to continue the sequence by typing a following number in the sequence, like “2.”

  3. 3

    Highlight the cells that you put numbers in and click on the fill handle in the lower right corner of the highlighted selection. Drag the handle down to complete as many rows as you want and the rows will be automatically numbered.

  4. 4

    Click on the “Tools” option from the top tool bar menu if you don’t see the fill handle appear. Click the “Options” button and then click on the “Edit” tab.

  5. 5

    Check the box next to the “Allow cell drag and drop” field. Every time you start to perform a function in a new row, or if you add a row, then a sequential number will automatically be updated.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.