Forum Discussion
Solved
formula autofill
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 f...
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...
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?
so if the cells on the right or left of the activecell are empty ,then it wont work?
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...