Oops. Wrong drag. My b.
One nice option you have in Excel is the ability to drag series values down, saving you the time of entering individual values for well-known lists. Here are a few data types you can drag to auto increment:
- numbers
- years
- months
- day of week
- date
- time
To take advantage of this shortcut, just add your first value, then click-and-drag the bottom-right corner of the cell as far as you need values filled in. Alternatively, if you’re working with a table of data, you can double-click on the bottom-right corner, and Excel will fill values to the row of the previous columns.
Click for larger image.
Another alternative is to create your own lists that you can later use to auto increment, such as student names, list of products, sales regions, members of a group, etc.
After you get comfortable with dragging lists that Excel provides baked in, you can start your own custom list in 2010 or 2011.
