Excel 16 - Ctrl-V does not hold for multiple pastes

[PeterMoran]

Hi,

I find lately that Ctrl-V (Paste) sometimes does not hold for multiple pastes (repeating Ctrl-V without a Copy each time).

Sometimes it works perfectly, then sometimes I have to do a Ctrl-C (Copy) for each paste.

Any similar experiences, or even better, any known solutions!

Thanks in anticipation.

 

[xwb]

Check your focus - is the sheet greyed out because it is waiting to complete an operation or something else has been selected?

 

[PeterMoran]

Hi xwb,

Thanks for your reply.

The focus seems ok, I copy and then want to do several repeated pastes down a page, and the data is lost after the first paste.

To do what I want I have to repeatedly copy and paste.

Other times I works fine!

 

[combo]

Any automatic macros in the file or add-in if Ctrl+V works only once?

combo

 

[Andrzejek]

When it does not work, have you tried this functionality in - let's say - a Notepad?


---- Andy

There is a great need for a sarcasm font.

 

[pjw001]

This has just happened to me.

I copied a number of cells and then repeatedly pasted them into other areas of the same spreadsheet. It then stopped working and I had to repeat the copy.

What caused it was that after the last paste before it stopped working I had deleted a cell.

Hope this helps.