Home

Auto fill issues with formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-560904%22%20slang%3D%22en-US%22%3EAuto%20fill%20issues%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560904%22%20slang%3D%22en-US%22%3EHello%20all%20I%20have%20entered%20the%20formula%20which%20has%20given%20me%20accurate%20numbers%20but%20when%20I%20use%20Auto%20fill%20to%20complete%20the%20row%20..it%20just%20repeats%20the%20selected%20number...help%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-560904%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561008%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20issues%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561008%22%20slang%3D%22en-US%22%3EYou%20may%20need%20to%20precede%20the%20Column%20letter%20of%20your%20cell%20reference%20with%20%24%20sign%20so%20that%20it%20becomes%20an%20absolute%20Column%20reference.%3C%2FLINGO-BODY%3E
jrat835
Occasional Visitor
Hello all I have entered the formula which has given me accurate numbers but when I use Auto fill to complete the row ..it just repeats the selected number...help
1 Reply
You may need to precede the Column letter of your cell reference with $ sign so that it becomes an absolute Column reference.