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.
Step1:
With the setup as above, double click on the square at the bottom right of the cells selected
HERE:
This will populate all relevant cells with the formulae!
It's as easy as that.
Video Training - Copy Down
- Nick's blog
- Login or register to post comments
- 8081 reads
Recent comments
5 years 44 weeks ago
6 years 30 weeks ago
6 years 42 weeks ago
6 years 44 weeks ago
6 years 45 weeks ago
6 years 51 weeks ago
7 years 7 weeks ago
7 years 7 weeks ago
7 years 7 weeks ago
7 years 7 weeks ago