We help IT Professionals succeed at work.

Paste in Excel not working

brianchess
brianchess asked
on
Medium Priority
3,793 Views
Last Modified: 2008-02-01
I am trying to copy & paste some data in Excel. When I go to paste it I get a msg stating
that "the data on the clipboard is not the same size and shape as on the clipboard and do
you want to paste anyway".
When I hit yes, it doesn't do any thing.
I looked at the choices for text on the clipboard and they are auto, text and OEM text.
Tried them all and none seem to work.

Help....
Comment
Watch Question

Commented:
brianchess,

You need to select either a single cell or the exact same size and shape of cells as was originally selected for the copy operation. The simplest way is  to select a single cell before pasting.

In other words, if you copy an area 3 columns wide and 12 rows long, when you go to paste you have to select either a single cell or an area 3 columns X 12 rows before pasting.

Are you doing this ?

Let me know if this solves your problem so I can repost as an answer. If it is not the problem, let me know and I will look deeper.

Steve

Commented:
shalbe,
Why do you post your answer as a comment?

Saar

Author

Commented:
I am doing only one colum of cells, as in the F colum.


I've done it on other machines.....

Commented:
You might be copying a very large amount of data to the clipboard.  Try copying and pasting your column part by part.  I don't mean cell by cell because that would take a long time.  You could try copying and pasting half of your column first and then the other half.  If it still doesn't work, try dividing it again.  If that still doesn't work, then I'll think of another suggestion.

Author

Commented:
Tried that.... still get the same prompt.
Would it be something in clipboard??

Saar
The reason Shalbe posts the answer as a comment is because he is polite enough to allow other people to comment if neeeded without locking the question. Brianchess can decide if the answer fulfills all his requirements. It's not about grabbing the points it is about helping others.....

Commented:
When you have selected the data you want to past.

Right click your mouse and paste special.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.