Skip to content

← Using a Computer, in Practice

Spreadsheets · 54 of 111

Fix a cell in place with a dollar sign

Expert guidance

Do this

Say B1 holds the bus fare, and column A the days traveled:

  1. In B3, type =A3*$B$1.
  2. Fill it down.
  3. A3 changes to A4, A5 and so on, while $B$1 stays put.

In LibreOffice Calc, click in the reference and press F4 to switch the dollar signs on and off. In Google Sheets and Excel, you can type them.

Why this way

Without the dollar signs, the next row would look for the fare in B2, which is empty, and give a wrong answer without a warning. Put a value like a rate or fare in one cell, so you change it once. Expert guidance.

Do it today

Work out a week’s bus cost at two different fares. 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