Filtering the new "Comments" in Excel

Question

Hi,

After my last Excel update the new type of threaded comments were implemented, replacing the old style "notes".

"Notes" could and can be filtered via "Go to special". Haven't found that function for the new comments yet.

Are there non-VBA solutions to this ? 

Next thing, printing all comments "at the end of sheet" is fine, but wouldn't it be smarter with the cell content of a defined column of the comment row instead of barely a cell reference. 

Thanks, smoo4what

Answer 1

Hi smoo4what,

I did a test with the latest version of Excel on my side both on Windows and Mac, but I cannot reproduce the problem you met.

The version of Excel for Windows is Office 365 for Business 1902(11328.20420). Right-clicking on a cell, the “New Note” button still there. And you can also use the Go To Special feature under Find & Select.

The version of Excel for Mac is 16.29.1.

You can also see the Note feature works normally.

In this case, we’d like to collect some information to narrow down the scenario:

1. Which operating system are you using? Windows or Mac? If you are using macOS, please provide the version of the macOS.
2. Which version of Office do you have?

Windows: After opening Excel, click File > Account, please provide a screenshot of the Product Information pane.

macOS: After opening the Excel client, click Excel > About Microsoft Excel on the menu.

And for the next thing you mentioned, it’s a good idea to send feedback to UserVoice, which is the official suggestion box for Excel. Other users will also be able to vote on the same post so that it will increase the awareness coming from the related team. More votes will make the team more aware that this is a highly requested feature.

Best regards,

Madoc

Answer 2

Hi Madoc,

thanks for your answer. I am running version 1902 (Build 11328.20420).

Sorry if I was unclear, I meant that me and my Excel version are capable of the exact thing you showed.

What's not working?=>

Use the "New comment" function instead (not a "Note"!), and these can't be found/filtered via "Go to special".

On top of that, printing all comments and having them only referred to i.e. "Cell X355" instead of some chosen cell content from that row i.e. "place yx". One could copy that from "Print titles - cell range" it'd be nothing new...

Kind regards, smoo4what

Answer 3

Hi smoo4what,

Sorry for the inconvenience it may have caused you.

For this kind of scenario, you can click on File > Feedback in Excel, then select "I Don't Like Something" to send feedback to the Excel development team, and don't forget to include the email address that our relevant team would contact you in time.

Thanks for your understanding.

Best regards,

Madoc

Answer 4

Hi smoo4what,

In past versions of Office, there did contain a selection of Comments when clicking on Go To Special.

However, Excel for Office 365 has changed the way comments work. Comments are now threaded, and allow you to have discussions with other people about the data. Notes are for making notes or annotations about the data, and work like comments used to work in earlier versions of Excel. For your reference: The difference between threaded comments and notes.

For your concern, Go to Special > Comments in the past version of Excel corresponds to the current Go to Special > Notes.

Sorry for the trouble with the changes in the function. Appreciate your understanding.

Best regards,

Madoc