SOLVED

Copying a formula down a row while keeping one cell constant

%3CLINGO-SUB%20id%3D%22lingo-sub-2783330%22%20slang%3D%22en-US%22%3ECopying%20a%20formula%20down%20a%20row%20while%20keeping%20one%20cell%20constant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2783330%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20really%20new%20to%20Excel%2C%20and%20I%20was%20wondering%20if%20there%20is%20a%20way%20to%20copy%20a%20formula%20down%20throughout%20a%20column%2C%20while%20keeping%20one%20of%20the%20cells%20the%20same.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20probably%20best%20if%20I%20write%20an%20example%20of%20what%20I%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%2050%20row%20sheet%2C%20and%20I'm%20trying%20to%20copy%20a%20formula%20(V5*Y2)%20down%20throughout%20the%20column%2C%20but%20keeping%20the%20Y2%20Constant.%20So%20I%20am%20hoping%20to%20copy%20and%20paste%20where%20it%20will%20only%20change%20the%20V%20value%2C%20so%20V6*Y2%2C%20V7*Y2%2C%20V8*Y2%2C%20and%20so%20on%20until%20V50*Y2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20copy%20it%20the%20way%20I'm%20familiar%20with%2C%20it%20changes%20to%20Y3%2C%20Y4%2C%20Y5%20and%20so%20on.%20Is%20there%20anyway%20I%20can%20make%20the%20Y2%20stay%20the%20same%20throughout%20the%20column%3F%20I%20really%20don't%20want%20to%20do%20it%2050%20times%20by%20hand%2C%20through%2012%20sheets%20haha.%20Thanks%20in%20advance%20for%20the%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2783330%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2783371%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20a%20formula%20down%20a%20row%20while%20keeping%20one%20cell%20constant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2783371%22%20slang%3D%22en-US%22%3EUse%20%24Y%242.%20That%20will%20fix%20the%20reference.%3C%2FLINGO-BODY%3E
New Contributor

Hello, I am really new to Excel, and I was wondering if there is a way to copy a formula down throughout a column, while keeping one of the cells the same. 

 

It's probably best if I write an example of what I want.

 

I have a 50 row sheet, and I'm trying to copy a formula (V5*Y2) down throughout the column, but keeping the Y2 Constant. So I am hoping to copy and paste where it will only change the V value, so V6*Y2, V7*Y2, V8*Y2, and so on until V50*Y2

 

But when I copy it the way I'm familiar with, it changes to Y3, Y4, Y5 and so on. Is there anyway I can make the Y2 stay the same throughout the column? I really don't want to do it 50 times by hand, through 12 sheets haha. Thanks in advance for the help

2 Replies
best response confirmed by Dre_Compomizzi (New Contributor)
Solution
Use $Y$2. That will fix the reference.