38. Excel Tips - Copy Down
Today's tip is about saving you precious time.
Suppose you have the following data, and you're trying to fill all cells with the correct formula:
In this example we have numbers 1 to 13, and we want the other 2 columns to be populated with the squares and cubes of the numbers. We have entered formulae in the first row, and want a quick way to populate the rest of the formulae without typing them in one by one.
With the setup as above, double click on the square at the bottom right of the cells selected
This will populate all relevant cells with the formulae!
It's as easy as that.
Video Training - Copy Down