Excel drop downs for copy/paste not functioning properly

Question

I was able to use Excel 2016 fine for college work earlier, but after I attempted to copy and paste a function, the option no longer exists. I've been trying to find a solution but I have found nothing so far.

Answer 1

Hi Rose,

I was trying to copy homework from before using Crtl+C then the drop down under Paste with the fx function. But now there's no option for the function at all. And no method that I can see to retrieve it.i Rose

If you wish to copy data to a range which includes data validation, you can select the paste special values and/or formats options. A simple copy/paste operation will overwrite the existing data validation.

If this it what has happened with your homework, I think that you will need to revert to a backup copy of your workbook.

===

Regards,

Norman

Answer 2

Hi  Rose,

I was able to use Excel 2016 fine for college work earlier, but after I attempted to copy and paste a function, the option no longer exists. I've been trying to find a solution but I have found nothing so far.

I may have misunderstood what you are  doing, but f you copy/paste to a cell within your data validation range, the cell's data validation may be overwritten. What options are you selecting for the paste operation?

===

Regards,

Norman

I was trying to copy homework from before using Crtl+C then the drop down under Paste with the fx function. But now there's no option for the function at all. And no method that I can see to retrieve it.

Answer 3

Hi  Rose,

I was able to use Excel 2016 fine for college work earlier, but after I attempted to copy and paste a function, the option no longer exists. I've been trying to find a solution but I have found nothing so far.

I may have misunderstood what you are  doing, but f you copy/paste to a cell within your data validation range, the cell's data validation may be overwritten. What options are you selecting for the paste operation?

===

Regards,

Norman

Answer 4

Hello, it is a pleasure for me to assist you with your request.

I would recommend to use the next link to proceed with a repair:

https://support.office.com/en-us/article/repair...

Let me know if you have any further questions.

Answer 5

I'd suggest doing an online repair of the installation. That should fix it.

The instructions to follow to do this are here:

https://support.office.com/en-us/article/repair...