Say, you have written a formula (or put a value) in cell B1 and you want to fill in this formula till B10000. You can drag the formula but higher the number of cells, more tedious it becomes. Fortunately, we have a way to do this very fast.
1. Put formula in B1.
2. CTRL+C of B1
3. CTRL+G and put the range say B2:B10000 in Reference: box (or even B1:B10000 as copying B1 in B1 will not cause any problem)
4. Press Enter
