Have a look in Excel Help at the OFFSET or INDIRECT functions - both
would allow you to do this.

Hope this helps.

Pete

On Oct 11, 11:02 pm, wrote:
I would like to know how to make a function that is copied along rows
by clicking the box until the + sign shows and dragging downward to
reference columns rather than rows.

For example, when copying a formula along the y axis (via the above
"click and drag" method so often used by all of us), the formula
naturally makes changes such that a reference to A4 becomes A5, A6,
A7, A8, ... etc. The reference changes along the y-axis as the
formula is copied vertically.

However, I need the formula to change from A4 to B4, C4, D4, E4, ..
etc as I copy the formula vertically using this same "click and drag"
method. Essentially, I'm asking about setting the row constant while
allowing only the columns to change AS I'M TRYING TO COPY FORMULAS
VERTICALLY. Can the direction of the "click & drag" copy function be
set to cross-reference (i.e. changing along the columns as I'm copying
along the rows)? Otherwise, I would have to go into each cell after
copying and change all the column values.