dont drag, copy paste special values/formulas then drag that if you need to