When creating cell references you can lock in either the ColRef or the RowRef
or both by the placement of dollar signs.

In your example, by changing ='10U'!A2.....
to: ='10U'!$A2 when you copy/paste you'll lock in Col_A
or
to: ='10U'!A$2 when you copy/paste you'll lock in Row_2
or
to: ='10U'!$A$2 when you copy/paste you'll lock in Col_A and Row_2

Note: When editing a cell reference...each time you press the [F4] key,
Excel will add or remove dollar signs. Play with that.

Does that help?

***********
Regards,
Ron


"cyn22" wrote:

How do I copy a formula from a group of cells to another group of cells
without excel editing the formula?

For example, I want the exact same formula from one group copied to another
group - as is - without any changes to it at all. For example, I am using
the formula ='10U'!A2 in one cell and want to go down 15 cells and have that
exact formula pasted there. When I do that, excel automatically changes the
formula to ='10U'!A16. I know I can copy from the formula bar, but what if I
want to do this for a large number of cells? It would take me forever. Help!