Can't Copy & Paste to a Range in Excel

  thegreypanther 16:36 PM 09 Apr 12
Locked

For some bizarre reason I find that I can no longer copy an entry from a single cell in Excel to multiple cells. e.g. copy a formula from one cell applied to all the other cells in that column.

I's happily worked before, but now the error message says "Data on the clip board is not the same size and shape.....".

What on earth has happened?

  compumac 16:46 PM 09 Apr 12

Had the same problem see http://www.pcadvisor.co.uk/forums/1/helproom/4130955/excel-copy-formulae-and-paste--will-not-paste/

I have found the problem intermittent, I discovered it works if you restart Excel again, although not every time. I initially thought that it was the particular file, but I now believe that the programme is the problem. Googling for it has not produced as far as I can see a satisfactory answer.

  thegreypanther 17:24 PM 09 Apr 12

Computers are bizzare...

I shut down the PC, gave it 5 minutes to cool, restarted, - and I can now copy and paste as before. And I thought that computers were meant to be logical!

Advertisement

This thread is now locked and can not be replied to.

OnePlus 2 UK release date, price, specification rumours: We're just hours away from the OnePlus 2 l2…

Why Vodafone’s frequency choice should interest you: The benefits of 800MHz

Motoman robots: from killing The Terminator to samurai swordmanship

Why Apple's being criticised for everything, even the good things