• 541K Members
• 6,287 Online
• 644K Conversations

## Question about copying a formula in Excel

Highlighted
Occasional Visitor

# Question about copying a formula in Excel

I am trying to copy a simple formula in excel but need the formula to change as I copy (and paste) it. The formula is (AG22/255)*T60. I know Excel will "follow" the sequences if I highlight a series of numbers in a cell and then drag into a corresponding series of cells (using the + sign in the lower right hand corner).

But when I attempt to do the same thing with the formula, both of my variables change in the formula (and I only need 1 to change).

So in the formula listed above, I need the sequence to repeat as (AG22/255)*T60, (AG23/255)*T60, etc.

Any ideas on how to only change 1 variable and not both?

Highlighted

# Re: Question about copying a formula in Excel

To do that, make the T60 as an absolute reference so that it doesn't change when you copy it down or across.

=(AG22/255)*\$T\$60

Related Conversations
Preparing a stacked chart
EuroSree in Excel on
0 Replies
Katharina_Stemmer1989 in Excel on
0 Replies
Linking external source (eg Share Price) to a cell
Aitch1964 in Excel on
0 Replies
Insert an image in Excel header
mat74 in Excel on
1 Replies
DAX Powerpivot - How to solve this problem in PowerPivot
kayyeah11 in Excel on
0 Replies
IF statements and conditional formatting
clare1981 in Excel on
1 Replies