Feb 01 2022 09:13 PM
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?
Feb 01 2022 10:22 PM
@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.
Feb 02 2022 08:03 PM
Feb 02 2022 08:58 PM
SolutionNo, 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...
Feb 02 2022 08:58 PM
SolutionNo, 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...