If re-designing the worksheet layout -- so that all input cols are placed
together to the left, with all formulated cols to the right (say) -- is out
of the question, then imo, no simpler option, you would have to drag down
each of the formula col in turn.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Appache" wrote:
I want to expand formula all the way down in the same row but I have a
problem. First cell is A2 secon column is D2 third column is G2 fifth is J2
and so on. Other cells between A2 and D2 or D2 and G2 is filled out so how
can I expand the formula without touching these cells. Is there any way to do
it?