How to Number in Order With Excel 2007

Save

Numbering items in your worksheet manually can be tedious, particularly if you have hundreds of items to number in order. You can have Excel do the work for you by using its Auto Fill feature. Using Auto Fill, you can fill a series of dates, days of the week, and of course, numbers. You need to let Excel know what pattern or series you want to create before it can number automatically for you.

  • Launch Excel to open a blank worksheet or load an existing worksheet.

  • Click on an empty cell where you want the number series to begin.

  • Enter the starting number you want, such as "1."

  • Click on an adjacent cell. If you want the number series to run across columns, click on the cell to the right of the one you just numbered. If you want the number series to run down, click below the first cell.

  • Type the next number in the series, for example, "2."

  • Select the two cells by clicking and dragging from the first cell to the second cell. Your selection should have a black outline around it.

  • Hover your mouse over the bottom right corner of the selection until you see a black cross appear. Click and drag, either down or to the right, for as many cells as you need to complete your series. Excel will automatically fill in the remaining numbers in order.

Tips & Warnings

  • Your numbers need not start with one nor be contiguous. You can create a series of all even numbers, all odd numbers, or even every Nth number, such as every fifth number.

References

Promoted By Zergnet

Comments

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!