Grid lines aren't deleted. You may be hiding them with a background
color, or you might not be referring to grid lines at all, but to Cell
Borders which is Cell Formatting. You didn't provide enough info to
determine which is the case.

racooncoat wrote:

How to stop grid lines being deleted when data is moved?