Using Excel’s fill handle to create an alphabetic list Your email ... Excel is smart enough to fill in lower or uppercase, accordingly. Check out this article I found on TechRepublic.