We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Can't Copy & Paste to a Range in Excel


thegreypanther

Likes # 0

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?

Like this post
compumac

Likes # 0

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.

Like this post
thegreypanther

Likes # 0

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!

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Best Christmas 2014 UK tech deals, Boxing Day 2014 UK tech deals & January sales 2015 UK tech...

IDG UK Sites

LED vs Halogen: Why now could be the right time to invest in LED bulbs

IDG UK Sites

Christmas' best ads: See great festive spots studios have created to promote themselves and clients

IDG UK Sites

Why Apple shouldn't be blamed for exploitation in China and Indonesia