You cant paste this here because the copy area and paste area are not the same size
Show
See how to fix Excel copy and paste problems and avoid multiple selections error messages. Also, prevent Excel from changing your formulas to values, when pasting multiple selections.
Video: Copy & Paste ProblemsThis video shows two problems you might have in Excel, when copying and pasting multiple selections, and how to avoid these problems:
The written steps are below the video. Video Timeline
Copy Error for Multiple SelectionsIf you select more than one group of cells on a worksheet, and try to copy them, Excel might show an error message:
Or, in some versions of Excel, you'll see this error message instead:
Why You See Copy ErrorExcel will show that copy error message if you selected multiple ranges, and those ranges don’t “match up”. For example, Excel will show a warning message if you
Avoid Excel Copy Error MessageTo avoid that copy error message, be sure to select multiple regions that DO "match up". All of the selected regions that you want to copy must be in either:
If even one of the selected cells does not match the other selections, Excel will show that error message. The screen shot below shows an example of two selections that DO match up.
No error message will appear when copying this multiple selection Paste Problem for Multiple SelectionsIf you copy more than one group of cells on a worksheet, and paste them in a different location, Excel might change your formulas to values. NOTE: This problem can cause serious problems, because Excel doesn’t give you a warning message. If you don't immediately notice that the formulas were changed to values, your workbook could have serious errors later. Paste Problem ExampleHere's an example, from my Excel workbooks, of how this copy and paste problem can damage your worksheets. One worksheet had a named Excel table, where some columns had formulas
I didn’t need all the data in the new workbook, so followed these steps, to copy and paste part of the data:
A few minutes later, in the new worksheet, I noticed a problem:
For troubleshooting the problem, I did these steps:
Here is the copied data, with the Show Formulas setting turned on
How to Paste the FormulasTo keep the worksheet formulas, when copying and pasting multiple selections, follow these steps:
With this technique, all the formulas will be pasted too. This can can help you avoid potential problems, caused by Excel pasting values, instead of formulas Video: Turn Off Paste Options in ExcelWhen you copy and paste in Excel, you might see option boxes, at the bottom right of the pasted data. You can click those buttons, to select an option for pasting the data, such as Paste Values. If you don't like those boxes, and never use them, watch this video to see the steps to turn this feature off. Note: For newer versions of Excel, click the File tab, instead of the Office button. Turn off Paste Options buttonsTo turn off the Paste Options buttons, follow these steps
Get the Sample FileCopy and Paste Problems: Download the sample file for multiple selections copy and paste problems, to follow along with the video. The zipped file is in xlsx format, and does not contain any macros. More TutorialsPaste, Skip Blanks Filtered List Paste Problems page Data Entry Tips Excel Table Why won't Excel let me paste values?Go to: File > Options > Advanced. Under Cut, copy and paste, ensure Show Paste Options button when content is pasted is checked.
Why won't Excel let me copy and paste between workbooks?The solution is to make sure that the workbooks are opened in the same instance of Excel. The easiest way to do this is to make sure that once the first workbook is open, you open the second workbook by using the Open tool on the toolbar or by choosing File | Open.
|