Remember the first time you typed a 1, and then a 2, and then dragged those cells to create a sequence of numbered cells?
You can do the same with other lists: Excel includes obvious ones like days of the week and months. What I really like about these is that you can start in the middle and they still work.
Access Analytics points out another good one: a list of letters you can drag.
In Excel 2010
- Type the list you want to be able to reuse. Sorry, no formulas.
- Click “File”
- Click “Options”
- Click “Advanced”
- Scroll down and click “Edit Custom Lists”
- Click the button to select a range, and select the list you typed.
- Click “Import”. Your list should appear in the box.
- Click “Add”
What sort of lists might you want to create this way?
- Upper case letters
- Lower case letters
- Roman numerals
- Ordinals (First, Second, Third, etc.)
- People’s last names
- People’s first names
Those last two are pretty useful for a teacher: I can quickly generate lists of students to mix and match for group projects, and such.
Here’s an odd one I’ve done. I give multiple choice exams on scantrons. The rows of “bubbles” for questions are in groups of 10. Sometimes, if I have more than one thing on a test, I have to give students a score out of questions 1-10, and say, 11-20. So I have a custom list that starts with those and goes up to 91-100.