SOLVED

formula autofill

%3CLINGO-SUB%20id%3D%22lingo-sub-3102805%22%20slang%3D%22en-US%22%3Eformula%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3102805%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%3C%2FP%3E%3CP%3Ei%20have%20one%20issue%20on%20one%20of%20my%20spreadsheets%2C%20when%20i%20double%20click%20at%20the%20cell%20%2C%20it%20doesnt%20autofill%20formula%20to%20below%20cells%3C%2FP%3E%3CP%3Ewhy%20is%20that%3F%20i%20checked%20in%20my%20options%20its%20enabled%20for%20dragging%20%26amp%3B%20in%20my%20formulas%20tab%20its%20automatic%20calculation%3C%2FP%3E%3CP%3Ewhat%20might%20be%20the%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3102805%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3103048%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3103048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F258847%22%20target%3D%22_blank%22%3E%40chahine%3C%2FA%3E%26nbsp%3BAre%20you%20clicking%20on%20the%20small%20square%20in%20the%20bottom%20right%20hand%20corner%20of%20a%20cell%3F%20That%20should%20work%2C%20but%20only%20if%20you%20have%20non-empty%20cells%20on%20either%20side%20of%20the%20active%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3108923%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3108923%22%20slang%3D%22en-US%22%3Ehello%20yes%20am%20clicking%20at%20the%20small%20square%2C%3CBR%20%2F%3Eso%20if%20the%20cells%20on%20the%20right%20or%20left%20of%20the%20activecell%20are%20empty%20%2Cthen%20it%20wont%20work%3F%3C%2FLINGO-BODY%3E
Frequent Contributor

hello

i have one issue on one of my spreadsheets, when i double click at the cell , it doesnt autofill formula to below cells

why is that? i checked in my options its enabled for dragging & in my formulas tab its automatic calculation

what might be the issue?

3 Replies

@chahine Are you clicking on the small square in the bottom right hand corner of a cell? That should work, but only if you have non-empty cells on either side of the active cell.

hello yes am clicking at the small square,
so if the cells on the right or left of the activecell are empty ,then it wont work?
best response confirmed by chahine (Frequent Contributor)
Solution

@chahine 

No, it won't work in that case.

Another way to copy down the formula is as below...

Say, your formula is in cell B2 and you want to copy it down up to B500, then type B2:B500 in the Address Box and hit Enter, the range B2:B500 will then be selected and then press the shortcut key Ctrl+D and the formula in B2 will be copied down up to B500. Refer to the screenshot below...

 

Address Box.jpg