Skip to content

← Using a Computer, in Practice

Spreadsheets · 53 of 111

Copy a formula down the whole column

Expert guidance

Do this

  1. In C2, type a formula, like =A2+B2, and press Enter.
  2. Click C2. There’s a small square at its bottom right corner.
  3. Drag that square down to the last row, or double-click it in Calc or Excel.
  4. Click C5 and read it: it now says =A5+B5.

In Google Sheets, you can also select the cells, and press Ctrl + D.

Why this way

This is called a relative reference: the program remembers “the two cells to my left”, not the fixed cells. LibreOffice’s help describes it. If a formula must always point to the same cell, use a dollar sign. Expert guidance.

Do it today

Add two columns of marks and fill the total down. Five minutes.

Where these facts come from

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do