Copy and Paste error HELP!

S

stan1986

New Member
Joined
Mar 23, 2009
Messages
8
"The information cannot be pasted because the Copy area are not the same size and shape. Try one of the following:


-Click a single cell, and then paste

-Select a rectangle that's the same size and shape and then paste"

I need to bypass this message. How?!?

I've tried both of the options given (single cell and rectangle) and neither have worked. I've tried the formatting tool which also give the same error message. Help!
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Sort by date Sort by votes
If your selected (copied) region is a complete column, you have to choose to paste to either a full column (by selecting the whole column) or select a single cell in row 1 of a column in the spreadsheet.
If you copied an entire row, you have to flip the logic 90 degrees:) and paste to either 1 or more complete rows, or to a single cell in column 1 of a given row.
Does that resolve the problem?
Cindy
 
Upvote 0
After some tinkering, I realized that I had spaced- I grouped some sheets together and needed to ungroup them before pasting a selection into the same workbook. Thanks so much for your suggestions though!
 
Upvote 0
stan1986 said:
"The information cannot be pasted because the Copy area are not the same size and shape. Try one of the following:


-Click a single cell, and then paste

-Select a rectangle that's the same size and shape and then paste"

I need to bypass this message. How?!?

I've tried both of the options given (single cell and rectangle) and neither have worked. I've tried the formatting tool which also give the same error message. Help!
Click to expand...

I am having this same problem. I want to copy A1.A100,000 form one 2007 workbook to another in cells A20001.A120000. The sizes are the same and neither have any merged cells or alignment issues that I can see.

Please help!!!

Thank you,

Wes
 
Upvote 0
Make sure you are ONLY selecting the cells you want to paste, not the entire columns. Make sure the workbook is not in compatibility mode (which will limit the number of columns and rows even if you're using 2007). Copy just the cells with the desired data, then select only cell A20001, then paste. If that doesn't work, I don't have any other ideas.
Hope this helps...
 
Upvote 0
stan1986 said:
"The information cannot be pasted because the Copy area are not the same size and shape. Try one of the following:


-Click a single cell, and then paste

-Select a rectangle that's the same size and shape and then paste"

I need to bypass this message. How?!?

I've tried both of the options given (single cell and rectangle) and neither have worked. I've tried the formatting tool which also give the same error message. Help!
Click to expand...

Maybe you have a filtered area active? Deactivate filter and try again.
 
Upvote 0
One way this issue occurs is when the pasted region would be greater than the size of the worksheet. For example, my worksheet is capped at 1,048,576 rows, so any paste that would lead to rows greater than that produces the described error.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Clipboard error when copying shape
Replies
4
Views
394
marc81
M
A
  • Question
Excel VB Organogram
Replies
1
Views
79
anuradhagrewal
A
Z
  • Solved
Using Radio Buttons to change images in a cell
Replies
3
Views
725
Micron
M
M
  • Question
VBA Event help, change shape of color as per option selections
Replies
5
Views
197
Jaafar Tribak
Jaafar Tribak
N
  • Question
Copying and pasting a long row has issues
2 3 4
Replies
36
Views
688
Asbestos_Jen
Asbestos_Jen

Forum statistics

Threads
1,214,827
Messages
6,121,812
Members
449,048
Latest member
greyangel23

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top