Column A in the following sheet contains a list of consecutive values. I've also entered the following formula in B1, which returns the letter A:
At this point, I could drag the fill handle down to create an alphabetic list (based on the values in column A), but I don't have to drag it at all. A simple double-click to the fill handle will automatically fill in the rest of the series. Excel knows where to stop, so don't worry about that - just double-click! It's an easy trick, but one still not well known.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.