Fill Handle

[jjcchheenn]

Is there a way to control the fill handle so that when you drag it down, it increments across instead of down?

IE: A1=1
B1=2
C1=3

when I go to cell E1 and insert '=A1', I get the result of 1. However, when I choose the fill handle and drag it down, the next cell references A2. Is there a way that it can reference horizontally (B2)?

Thanks,

 

[johnr715]

after u do your fill on column A select all the cells with values in column A >edit >copy

Select B1 edit>paste special>transpose

 

[JohnnyTightlips]

You can't control the fill handle (maybe with VBA?), but you can do it with a formula if you want to keep it dynamic. Enter this formula in cell E1:

=OFFSET($A$1,0,ROW()-1)

When you drag down it will increment across instead of down

 

[jjcchheenn]

Thanks Johnny!!! That was exactly what I was looking for ray: