• Excel Book Excerpt

Excel Teach Excel to Fill A, B, C

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Teach Excel to Fill A, B, C

Problem: The fill handle can fill weekdays, months, quarters, and now numbers. Why can’t it fill A, B, C?

Strategy: Create a list of the alphabet. Save that list as a custom list as described above. Here is a fast way to create the alphabet.

1. Select a range that is one column wide and 26 rows tall.

2. Type =CHAR(ROW(A65)). Press Ctrl+Enter.

3. Ctrl+C to copy. Paste, Values using your favorite method or Context+V in Excel 2010.

Character number 65 is a capital letter A. Using ROW(A65) will return the number 65 in the first cell, 66 in the next cell, and so on. This handy formula will create the letters from A to Z.

Import the range as a custom list as described in the previous topic.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: