You tell Excel a value is constant by prefixing its column and/or row reference with a $ sign. This way, when a calculation is copied the reference remains constant.
e.g. in the following VAT calculation each value is multiplied by the same, constant rate. To insert the $ sign, press F4 which cycles through all the permutations.