0
votes
1answer
312 views

Why doesn't formula work on COPIED data?

I'm using countif formulas across two and three columns in an Excel 2010 spreadsheet. The formulas work perfectly on data that is ENTERED but not on data that is COPIED into the spreadsheet, even ...
2
votes
1answer
748 views

Can not copy (much) between instances in Microsoft Excel

I have a user who is not able to copy much data from one instance of Excel to another. Copying and pasting within an instance works fine, but if I open up two instances I quickly get the error: ...
1
vote
2answers
3k views

Creating a command to clear clipboard in Excel 2010

I would like to make a command that will clear (reset) Clipboard while I am using Excel 2010. I would prefer this as a button in Excel, but it can be a shortcut on the desktop as well. Is there any ...
0
votes
1answer
4k views

How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
0
votes
1answer
690 views

excel 2010 open dialog window after changing formula

I have to copy 120 thousand formulas from one xls file to another. After a simple copy-paste, the original file name is inserted into the formula, not good. I tried to remove it with Data - Links, but ...
0
votes
1answer
2k views

Special-Pasting a hyperlink in Excel

Is there a way to use the Paste Special command to paste a hyperlink from one cell in Excel 2010 to another cell? I am asking specifically about the Paste Special command, not the Paste Link or ...
1
vote
3answers
6k views

Paste a range into a filtered table

We have the following excel sheet: The cells A2 to A10 are filtered: option 3 and option 4 are filtered out. Now we want to paste the numbers in A12:A16 next to the visible cells (so in B2:B10). ...
1
vote
0answers
3k views

Google Chrome Interferes with Copy and Paste in Excel

I have got the following problem: Copy (Ctrl+C) and Paste (Ctrl+V) function in Excel 2010 does not work (or acts weirdly) if I have Google Chrome opened at the same time. This issue is Excel-specific ...
0
votes
1answer
2k views

Excel 2010 - Copy doesn't drag / Pasting option is only Unicode Text

It seems that when I copy a cell, it is not highlighted and cannot be dragged and the only paste option is unicode text or text. I checked File-Options-Advanced-Editing Options and I have my "Enable ...
4
votes
3answers
8k views

Excel, cut-n-paste ERROR-MESSAGE: “The picture is too large and will be truncated.”

ISSUE: Possible it's not related, but I just installed IE9, and now I'm getting this an error when I try to copy-n-paste a relatively small amount of text: Excel Error Message: "The picture is too ...
2
votes
3answers
8k views

Cell colors change when copy&paste in Excel 2010

We have a 3rd party tool that creates an Excel file (xls, 97/2003 format) and formats some cells in different colours. When I copy a range of cells into a newly created file (xlsx, 2007/2010 format) ...
2
votes
1answer
3k views

Is there a way to copy an Excel worksheet without copying all of the cell styles in the source workbook to the target workbook?

The title pretty much says it. I have an Excel document with tons of randomly named styles that I didn't create but that I want to copy a worksheet from. When I do, it drags all of those styles into ...