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!