Forum Discussion
formula autofill
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...
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.
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...