Page 1 of 1

[Solved] Problem with Paste Special

PostPosted: Tue Nov 19, 2019 11:50 am
by AliGee
I try to enter a value in say Cell A17, without entering data, the cursor leaps to Cell CB17 (the last populated column) and opens the Paste Special Box. :crazy: Can anyone please help ?

Re: Problem with Paste Special

PostPosted: Tue Nov 19, 2019 1:49 pm
by Zizi64
I suppose it: there are "data separator" characters in the content what you want to paste.

- try to "merge separators" option
- or copy only the real content onto the clipboard.

Re: Problem with Paste Special

PostPosted: Tue Nov 19, 2019 6:46 pm
by AliGee
Thank you for your reply, wasn't trying to paste anything just entering data in the spreadsheet. I seem to have resolved the problem, probably by accident rather than by design but I will certainly bear in mind your suggestion should the issue reappear.

Again many thanks for your input.