?
Solved

Paste in Excel not working

Posted on 1998-07-04
8
Medium Priority
?
3,113 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....
0
Comment
Question by:brianchess
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 3

Expert Comment

by:shalbe
ID: 1612681
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
 
LVL 4

Expert Comment

by:saar2
ID: 1612682
shalbe,
Why do you post your answer as a comment?

Saar
0
 

Author Comment

by:brianchess
ID: 1612683
I am doing only one colum of cells, as in the F colum.


I've done it on other machines.....
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Expert Comment

by:wsanchez
ID: 1612684
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
 

Author Comment

by:brianchess
ID: 1612685
Tried that.... still get the same prompt.
Would it be something in clipboard??

0
 

Expert Comment

by:grizzle053098
ID: 1612686
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
 
LVL 1

Expert Comment

by:CEBAKA
ID: 1612687
When you have selected the data you want to past.

Right click your mouse and paste special.
0
 
LVL 1

Accepted Solution

by:
x30 earned 100 total points
ID: 1612688
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question