If you have some formula in cell A3, go to cell A4 and press Ctrl+D and the formula will be copied there in cell A4.Similarly, cover cell A3 to A15, and press Ctrl+D, the formula will be copied from A4 to A15
.Same thing you can perform in right cell to the cell of formula by pressing Ctrl+R, in our case, B3.
This tip is contributed by Pramod Jain
No comments:
Post a Comment