SOLVED

Freeze a value in autofill

%3CLINGO-SUB%20id%3D%22lingo-sub-3215129%22%20slang%3D%22en-US%22%3EFreeze%20a%20value%20in%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3215129%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20if%20there%20is%20a%20way%20to%20prevent%20one%20of%20the%20values%20from%20autofilling%20when%20using%20autofill%3F%20For%20example%2C%20if%20I%20have%3C%2FP%3E%3CP%3E%3Db2*a1%20and%20use%20the%20plus%20to%20drag%20down%20to%20autofill%2C%20I%20get%3C%2FP%3E%3CP%3E%3Db3*a2%20but%20what%20I%20want%20is%26nbsp%3B%3C%2FP%3E%3CP%3E%3Db3*a1%20so%20when%20I%20drag%20down%20through%20hundreds%20of%20rows%20a1%20stays%20static%20but%20b3%20continues%20to%20autofill.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3215129%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3215142%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20a%20value%20in%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3215142%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1294171%22%20target%3D%22_blank%22%3E%40MHDesign%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DB2*%24A%241%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3215471%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20a%20value%20in%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3215471%22%20slang%3D%22en-US%22%3EYes%2C%20perfect!%20Thank%20you!!%3C%2FLINGO-BODY%3E
New Contributor

Does anyone know if there is a way to prevent one of the values from autofilling when using autofill? For example, if I have

=b2*a1 and use the plus to drag down to autofill, I get

=b3*a2 but what I want is 

=b3*a1 so when I drag down through hundreds of rows a1 stays static but b3 continues to autofill. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@MHDesign 

=B2*$A$1

Is this what you are looking for? 

Yes, perfect! Thank you!!