Hi

You cannot change the way that Excel works. You can amend formulae to
pick up data from other cells using Offset or Index.
In cell A2, enter
=INDEX(1:65536,1,ROW())
and copy down
This will pull values from B1, C1 etc. as you go down the column.

--
Regards

Roger Govier


"Stratful" wrote in message
...
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!