← 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:
- In B3, type
=A3*$B$1. - Fill it down.
A3changes to A4, A5 and so on, while$B$1stays 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
- Addresses and References, Absolute and Relative, LibreOffice 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.
