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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
218 Replies