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

HTH
Kostis Vezerides

On Apr 30, 1:54 pm, Stratful
wrote:
I wish to chabge the way in wich Excel updates the cell references when
dragging formulas at the moment if dragging down Excel does the following
A1,A2, A3 etc..
I would like Excel to do the following A1,B1,C1.

All help will be gratefully receieved!