To prevent Excel from creating new rows and columns automatically, follow these steps: Here you can find a setting named Include new rows and columns in table. You need to double-click on this setting ...
If you’re still dragging columns around, you’re doing extra work.