My spreadsheet has rows with cells that contain either numerical values or formulas that use these values (they access only values from the same row). Each row corresponds to an event, when an event of this type happens there should be a new row. The formulas never change.
Now I insert a new row, copy the last one and paste it over the new one. It clones the formatting (which is good), the formulas with updated references (which is good) and the data (which is very bad). Then I type the new data over. It seems very error-prone.
What is the right way to do it? It has to be an idiom.