Question
October 3, 2007 at 06:24 PM
hazcon

Moving data in Excel

by hazcon . Updated 19 years, 1 month ago

I have an excel spreadsheet template with multiple formulas. Users do not access the formulas but they have a horrible habit of dragging the bottom row of data to the top and then filling down when starting a new form. This throws everything out as now the last formula is referring to the top line and there are no formulas for the following data due to the drag and fill.
Is there a way to make the formulae always refer to a particular cell even if someone “drags” that cell somewhere else?

This discussion is locked

All Comments