I have a worksheet that imitates a scrum board. Rows represent cards. Therefore I want to allow users to be able to drag and drop rows easily to shift them around like physical cards. I have code to do this.

However, enabling drag and drop "shift-entire-row" also enables the drag auto-fill values/formulas - so when users use the "+" feature, it will overwrite entire rows with the row being dragged - which I don't want. Each row has to uniquely identify a single card, no duplicates.

How do I allow the drag and drop entire row, but disable the drag "auto-fill formulas" feature?

Thank-you!