Sheldon has some tips Addressing Dynamics GP Copy & Paste from Excel Issues
Addressing Dynamics GP Copy & Paste from Excel Issues – Etelligent Solutions-
Archived post from 2015. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.