Type A1 =a
a2 =b .... a26 =z
Tools Options cutom Lists Import list from cells: select your range
click Import

In excel sheet when you type "a" (no quote) and drap down it will change to
b, c, e...so on


"art" wrote:

Every time you drag down or up the numbers change. And if you drag right or
left it changes abc's. How can I make that when I drag down it should go
something like B, C, D... and so on, Instead of going 1, 2, 3.