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.

Download Practise sheet

Video Training - Copy Down