Referencing rows to columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.

.

Relevant Pages

  • Re: Referencing rows to columns
    ... Have a look in Excel Help at the OFFSET or INDIRECT functions - both ... when copying a formula along the y axis (via the above ... naturally makes changes such that a reference to A4 becomes A5, A6, ... etc as I copy the formula vertically using this same "click and drag" ...
    (microsoft.public.excel.misc)
  • Re: Referencing rows to columns
    ... Enter this in any cell and drag down to copy, and this will copy Row 4 ... when copying a formula along the y axis (via the above ... naturally makes changes such that a reference to A4 becomes A5, A6, ...
    (microsoft.public.excel.misc)
  • Re: Referencing rows to columns
    ... Can you show us your formula in a cell like A1 and show us what you want ... when copying a formula along the y axis (via the above ... "click and drag" method so often used by all of us), ... naturally makes changes such that a reference to A4 becomes A5, A6, ...
    (microsoft.public.excel.misc)
  • Re: REQ: High Performance Access to a Static Objects List
    ... one reason to copy to a local variable would be so that the static object's reference could be updated by one thread without affecting the instance being used by another. ... Easier would be to synchronize all access to the list, but then even readers of the list would wind up serialized, which could hinder performance. ... If each element of the list requires extensive time to process during the iteration then it's possible copying the list could speed things up. ... However, you may still have synchronization issues between individual list elements if you do a shallow copy, or you may not find there's any significant performance benefit if you do a deep copy. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: RE DateFunction
    ... That $A1 reference was given to allow the copying down of the formula so ... Excel and Word Function Lists available free to good homes. ...
    (microsoft.public.excel.worksheet.functions)