Browse » Home
Thursday, February 24, 2011
How to Automatically Number Rows for an Excel Spreadsheet
1. Open the Microsoft Excel application on your computer. Click on the first cell where you want to establish a numbered pattern.
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. 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. 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. 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.