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.

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.

Assuming you mean the cell references, you can only do this with a formula


=OFFSET($A$1,,ROWS($A$1:A1)-1)

or the non volatile

=INDEX($1:$1,0,ROWS($A$1:A1))

will return what's in A1, B1, C1 and so on


Regards,

Peo Sjoblom

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.

Thanks for the reply. But I cant figure out exactly how to do this. My
formula in the cell Until now was
=SUMPRODUCT(--('[Waccount.xls]Daily
Totals'!$B$6:$B$12=Year_2006),--('[Waccount.xls]Daily
Totals'!$C$6:$C$12='[Waccount.xls]Daily Totals'!A$4),('[Waccount.xls]Daily
Totals'!E$6:E$12))

The last part "E$6:E$12" is what I need should change when I pull it down to
F$6, G$6, H$6 and so on. Any help?


"Peo Sjoblom" wrote:

Assuming you mean the cell references, you can only do this with a formula


=OFFSET($A$1,,ROWS($A$1:A1)-1)

or the non volatile

=INDEX($1:$1,0,ROWS($A$1:A1))

will return what's in A1, B1, C1 and so on


Regards,

Peo Sjoblom

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.