Excel 365 - UNABLE TO COPY DATA AND PASTE IN CUSTOM FILTER

Question

Hi,

In general, I am able to copy data in excel and paste within Excel/elsewhere. However, if I copy a cell (cell is highlighted with dotted lines) but I am unable to paste under Filter drop down (Text filter->Custom Filter)

I am using Office 365 (updated as on date). I tried to resolve the issue by rebooting the computer, uninstalling and reinstalling Office 365. there are no add-ins in the Excel 365 I am using.

Answer 1

Thank you Stacey.

I noticed an update availability in 'Open Excel>File>Account' option while arranging the screen shot you requested for.

The issue is resolved after I updated the product (excel).

Thank you so much for your efforts.

Sreenath

Answer 2

Hi Sreenath

Thanks for posting the thread on our forum.

According to your description, it seems that you can’t copy  and paste cell in highlighted  under custom filter.

I’ve did a test on our environment and I’m sorry to tell you that we can’t reproduce your problem.

Please try to create a new workbook to see if the problem will happen.

In order to help us narrow down the problem and solve it, we want  to confirm some information with you:

1）Can you provide the screenshot of  Excel product information for us? Open Excel>File>Account to give a screenshot.

2）From the first screenshot in your post, it looks you are using Excel application on Windows device but the second screenshot where problem happens doesn’t seem like Excel app on Windows device because of Custom Filter window is different. So, can I know the Device OS using at your end?

3）As you mentioned, you tried uninstalling, can I know whether you tried uninstalling via Control Panel or using Uninstall tool?

Appreciate your patience and understanding.

Regards,

Stacey

Answer 3

Hi Stacey

I am also facing the same problem. Previously I have no problem with copy and paste cell in highlighted under custom filter but now I can't. I tried to restart but problem still remain. This is really frustration Please help.

Here is the screenshot of the Excel Product.