38. Excel Tips - Copy Down

Nick's picture

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:
copy down

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
copy down

This will populate all relevant cells with the formulae!

It's as easy as that.

copy down

Download Practise sheet

Video Training - Copy Down