# Copy & pasting Formula with one constant cell and one mo

This is a discussion on Copy & pasting Formula with one constant cell and one mo within the Excel Questions forums, part of the Question Forums category; I am trying to copy and paste the following formula where the Formula Adjust E10 stays constant and the D23 ...

1. ## Copy & pasting Formula with one constant cell and one mo

I am trying to copy and paste the following formula where the Formula Adjust E10 stays constant and the D23 changes for each row. =SUM(D23*'Formula Adjust'!\$E\$10*1.07)

I can't figure out how to keep the one constant - it keeps tring to change - on the next line it looks like this - =SUM(D24*'Formula Adjust'!E11)*1.07 - I want to keep the link to the same cell while the other changes going down.

2. ## Re: Copy & pasting Formula with one constant cell and on

I am not quit sure what you mean, but try it with just one \$.
\$E10 or E\$10

3. ## Re: Copy & pasting Formula with one constant cell and on

Originally Posted by Starlightjewel
I am trying to copy and paste the following formula where the Formula Adjust E10 stays constant and the D23 changes for each row. =SUM(D23*'Formula Adjust'!\$E\$10*1.07)

I can't figure out how to keep the one constant - it keeps tring to change - on the next line it looks like this - =SUM(D24*'Formula Adjust'!E11)*1.07 - I want to keep the link to the same cell while the other changes going down.
You don't need the outer SUM and

copied 1 row down, would become:

because E10 is completely locked, while E\$10 would also work as intended.

4. ## Re: Copy & pasting Formula with one constant cell and on

Originally Posted by Starlightjewel
I am trying to copy and paste the following formula where the Formula Adjust E10 stays constant and the D23 changes for each row. =SUM(D23*'Formula Adjust'!\$E\$10*1.07)

I can't figure out how to keep the one constant - it keeps tring to change - on the next line it looks like this - =SUM(D24*'Formula Adjust'!E11)*1.07 - I want to keep the link to the same cell while the other changes going down.
It looks like you are doing it correctly -- anchoring the row and column on the E10 reference. Are you using copy/paste?

5. ## Re: Copy & pasting Formula with one constant cell and on

I'm not sure what I did differently, but I tried everything above and it's working now. I have 250 tabs to fix and really didn't want to do it manually. Thanks so Much!!!!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•