Can't Copy & Paste to a Range in Excel

  thegreypanther 16:36 09 Apr 2012
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 09 Apr 2012

Had the same problem see http://www.techadvisor.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 09 Apr 2012

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!

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

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

Iconic New York graphic designer Milton Glaser on his uplifting new subway posters

New iMac Pro release date, UK price & specs rumours

Comment suivre le parcours du père Noël ?