[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3251
  • Last Modified:

Paste in Excel not working

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....
0
brianchess
Asked:
brianchess
1 Solution
 
shalbeCommented:
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
0
 
saar2Commented:
shalbe,
Why do you post your answer as a comment?

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


I've done it on other machines.....
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
wsanchezCommented:
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.
0
 
brianchessAuthor Commented:
Tried that.... still get the same prompt.
Would it be something in clipboard??

0
 
grizzle053098Commented:
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.....
0
 
CEBAKACommented:
When you have selected the data you want to past.

Right click your mouse and paste special.
0
 
x30Commented:
Some times if you want to paste (or embed) other thing from any other aplication like sound or graphics, you can not just simply copy and paste, you have to put an emebed statement in your cell, to acceses that information Try the fx EMBEBED=
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now