Copy and Paste Cells

Write a formula once, then copy it down a column — Excel adjusts it for every row.

You will learn to

• Copy a cell and paste it into a range
• See relative references adjust
• Copy a formula across

How it works

Select the cell, press Ctrl+C, select where it should go (one cell or a whole range) and press Ctrl+V. When you paste a formula, its references move with it: =B2*C2 copied one row down becomes =B3*C3. That is why you only ever need to write a row formula once.

=B2*C2