You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

The information cannot be pasted because the copy and paste areas are not the same size and shape

The information cannot be pasted because the copy and paste areas are not the same size and shape

Price: FREE

message in Excel 2010. Basically I have a sheet that has multiple values in it. I have a vlookup formula that references a sheet in the same workbook. When I use autofilter to select certain values and paste special (e.g. the filter displays values in cells D1556, 1560 and 1562 so those in between are hidden)-values I get the error message:
'The information cannot be pasted because the copy and paste areas are not the same size and shape'. I think this was a bug in previous Excel versions and I think a workaround was to open the file disable autofilter and save and then re-open but this hasn't worked for me. I've also tried selecting visible cells only but then I get the message 'The command cannot be used on multiple selections'.
Is there any workaround?

Visit publisher's web-site: The information cannot be pasted because the copy and paste areas are not the same size and shape

Category and Tags: ExcelTutorials :

Related Tutorials

Copy/paste Issue

Free: Yes
Tags: Excel ›

I want to copy a block of data - 7 columns worth, and paste it to a separate worksheet in my w/b - the first block copies/pastes fine, but when I try to paste a 2nd block of data below the first block, I get the following error message:
The information cannot be pasted because the copy area and the paste 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.
... the problem is I want to do this programmatically via a macro, not manually - is there a work-around for this ?

When I special paste and transpose....

Free: Yes
Tags: Excel ›

When I select my row, copy, special paste, and transpose a message that reads:
The information cannot be pasted because the Copy area and the paste 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 have no idea what this means. Any help out there?

data on clipboard is not the same size and shape

Free: Yes
Tags: Excel ›

A couple of days ago, I started having trouble copying and pasting. The error message: data on clipboard is not the same size and shape as the selected area. Do you want to paste anyway? I have tried clearing the clipboard but it won't allow me to copy and paste formulas. It also appears to be clipped to Word. When I close Excel and reopen it the data is still on the clipboard.

Copy Paste problem when filter is on

Free: Yes
Tags: Excel ›

I have two excel files. In one file I have 475 entries. When I apply filter I get 175 entries. Now In the other excel file I have some data for those exact 175 entires . I wanted to copy those data for each column from excel file 2 and wanted to paste in file one. If I paste directly, it will never matches the corresponding cells. I tried to select the visible cells only option in the file one and then tried to paste the column data, but it didn't work. It says "the information cannot be pasted because the copy area and the paste area are not in the same size and shape"
Is there any way I can copy data from file 2 i.e .(without filters) and paste in file 1 (with filters).

I cannot get a column of data to paste into a new workbook

Free: Yes
Tags: Excel ›

I am simply trying to paste one column of data from one workbook to another and I keep getting an error message that the copy cannot be pasted because the copy area and the paste area are not the same size and shape. What am I doing wrong? I thought this should be a simple function to perform. Can anyone please help because I am doing a project and am stuck!

Related Applications & Scripts

Tape Cassette Loader

Free: No
Tags: Flash › Excel Preloaders

Old Style Tape Cassette Preloader. 100% Vector Graphics Small size!! swf file is only 7 kB! Allow to scale any size. Easy to change colors. Just copy and paste the into your frame!. And use itYou can make great music web site intro.

Interactive Bubbles

Free: No
Tags: Flash › Excel Mouse Tricks

Play with the flash bubbles, press them, push them. Resizable movie, easy to use: just copy and paste inside your movies.
AS is include in every bubble in order you can modify it and make every bubble have different reaction to the mouse events, just modify the numeric values of speed and position.
The size of bubbles file is 5 kb, but sample size is 20 kb because of the background.

Database Code Generator

Free: No
Tags: PHP › Excel CRUD Databases

It hooks into your database and generates HTML and PHP code that you can copy and paste into your project. Instead of having to write a form – you can copy and paste one – customized to your database structure!! Instead of having to write the code to process your POST request, you can copy and paste it. Instead of having to write INSERT , UPDATE, or SELECT statements, you can copy and paste it. Instead of… well, you get the picture.
Features:
- AJAX, HTL, HTML5 Forms
- Basic Sanitization
- Database CRUD Operations

SuperFormula Shape Flex Component

Free: Yes
Tags: Flash › Excel Components Flex

This is a little flex component that displays a SuperShape Formula. The application lets you alter the properties of the Superformula Shape.

Highlighting Form Text Areas on Mouse Click

Free: Yes
Tags: JavaScript › Excel Forms

This simple script set shows how to highlight (select) the text in a form's textarea by clicking on a link. Useful for code listings, order form information, or other material the visitor may wish to copy to the clipboard with Control+C.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing