Forum Discussion

PPDR901's avatar
PPDR901
Copper Contributor
Jan 11, 2019

Drag and Drop

On a simple worksheet I am trying to drag and drop data from one cell to another (simply moving data).

However if the field that it came from has either border or fill, it copies the border or fill along with the data.

Is there any way to move just the data? Other than the copy and paste function.

Thanks

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    No, with drag & drop that doesn't work, only with cut/paste special

  • Rich99's avatar
    Rich99
    Iron Contributor
    Use "Paste Special" where you can specify what you want to paste into a cell