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:
Other People Are Reading
Things you need
- Microsoft Excel
Open the Microsoft Excel application on your computer. Click on the first cell where you want to establish a numbered pattern.
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.”
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.
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.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for