MrExcel.com - Your One Stop for Excel Tips & Solutions

Teach Excel to Fill A, B, C

September 27, 2021 - by

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.

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.

This article is an excerpt from Power Excel With MrExcel

Title photo by Brett Jordan on Unsplash