在Excel 的每个实例中打开一个工作簿。 然后,您打算使用以下“选择性粘贴”菜单命令将属性从一个工作簿中的单元格粘贴到另一个工作簿中的单元格: 在这种情况下,不能将任何属性粘贴到其他工作簿中。 “Excel选择性粘贴”对话框未显示。 相反,将显示以下 Windows粘贴特殊对话框: 因此,不能选择以下任一选项: 公式 值 Formats ...
Solution 10: Fix Microsoft Excel Cannot Paste the Data Error with Repairit Excel Repair If you find that your Excel file has been corrupted, you would benefit from an Excel repair tool. Not just any Excel repair tool, but a functional, reliable one that will ensure that all your data will...
If you attempt to paste the values where the paste area is smaller than the copied area, Excel will send you“You can’t paste this here because the Copy area and paste area aren’t the same size.” To solve this error, all you need to do is paste in the empty cells or the area...
Microsoft Excel cannot paste the data as a picture.Method 2 – Using Paste As Picture OptionSteps:Select the range of cells B2:D14. Press ‘Ctrl+C’ to copy the data.Go to the sheet where you want to paste the data. Right-click on your mouse, and from the Paste as Special arrow ...
Learn how to fix the 'Microsoft Excel cannot paste the data' error with our expert tips. Solve your Excel paste error problems today!
How to Fix Microsoft Excel Cannot Paste The Data (10 Fixes) The Excel issue is quite common when copying and pasting data from one spreadsheet. In some instances, you can be experiencing difficulties because of merged cells or a lack of familiarity with the multiple copy-pasting processes, bot...
The copy area and the paste area are not the same size and shape, so select the upper-left range instead of the whole range before you paste the information into the cell. Microsoft Excel cannot paste the data Follow the solutions below to fix theMicrosoft Excel cannot paste the dataerror...
This happens because the Excel copy command doesn’t operate on different rows and different columns at the same time. Select any range of cells in columns B and C and copy them. It’ll work. Select any cells present in rows 4,5,6, and 7 and copy them. The above-mentioned problem ...
If Excel does not open the file after you turn off all the add-ins, the problem has a different cause. If none of the above options works, please make sure Excel is not in Compatibility mode. If you still experience this problem after you try all these options, contactM...
ll be the same file, but everything will just be tiny. I know Mac OS has something to do with it, because they obviously have very nice screens that they like to show off by making the fonts very small. However, it gets really annoying to have to zoom in all the time just to ...