You use $ symbols to do that.
e.g if you reference the cell E9 then use $E$9 in the equation, so when you copy the equation to a whole column they will all use E9
@neu started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
You use $ symbols to do that.
e.g if you reference the cell E9 then use $E$9 in the equation, so when you copy the equation to a whole column they will all use E9