← Using a Computer, in Practice
Spreadsheets · 53 of 111
Copy a formula down the whole column
Expert guidance
Do this
- In C2, type a formula, like
=A2+B2, and press Enter. - Click C2. There’s a small square at its bottom right corner.
- Drag that square down to the last row, or double-click it in Calc or Excel.
- 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
- Addresses and References, Absolute and Relative, LibreOffice Help.
- Keyboard shortcuts for Google Sheets, Google Docs Editors Help.
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.
