Can't Copy & Paste to a Range in Excel

  thegreypanther 16:36 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 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 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.

Best Samsung Galaxy S7 deals: Where to buy Galaxy S7 & Galaxy S7 Edge

1995-2015: How technology has changed the world in 20 years

How Toca Boca designed the characters, UX and gameplay for Toca Dance

Why programmers think Mac OS X is the best operating system to use for coding