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

The 30 best TV shows on Netflix UK: Our pick of the best programmes you can watch right now

IDG UK Sites

Nostalgia time: Top 10 best selling mobile phones in history

IDG UK Sites

VFX Emmy: Game of Thrones work garners gong for Rodeo FX

IDG UK Sites

Apple 13-inch MacBook Pro with Retina review (2.6GHz, 128GB, mid-2014)