Excel 365 insert comments show up reverse order (Oldest at top, Newest at bottom)

[gdsrwq421]

Hoping anyone can help.

Sometimes our team collaboration causes a single cell to have ~100-200 replies.

I can't understand why Excel made is so that old comments show up first and new ones, way way way at the bottom.

Does anyone know if there is any way to reverse this?

Thank you!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel 365 insert comments show up reverse order (Oldest at top, Newest at bottom)
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[gdsrwq421]

Apologies, I've already removed (marked as solved the posting in ExcelForum)

 

[gdsrwq421]

Hopefully, I can still ask the community from this thread.

Thank you for bringing to my attention, will not crosspost moving forward.

 

[RoryA]

Please read the rules. They do not say that you cannot cross-post, just that you need to provide links to any crossposts in other forums.

 

[gdsrwq421]

Ok, got it, thank you misunderstood, and makes sense

 

[Trevor G]

Hoping anyone can help.

Sometimes our team collaboration causes a single cell to have ~100-200 replies.

I can't understand why Excel made is so that old comments show up first and new ones, way way way at the bottom.

Does anyone know if there is any way to reverse this?

Thank you!

Hi and welcome to the Board. Can you clarify. Single cell has 100 to 200 replies. Old comments show up first.

Are these actual cell comments (Like a post it note)?

Would you be able to show an example of what you have (you can hide any sensitive data) which may help in receiving a solution.

There is an Add-In called Inquire (Com Add-In) which will help analyse and show comments in an additional workbook that you can integrate etc.

 

[gdsrwq421]

This has been crossposted at

Reddit:

https://www.reddit.com/r/excel/comments/1d8rmee/comment/l783d98

MSN Forum: Excel 365 insert comments show up reverse order (Oldest at top, Newest at bottom)

 

[Trevor G]

Your reply #8 doesn't answer my question. I can only assume your looking to use the Review Tab and comments or am I wrong?

 

[gdsrwq421]

Hi and welcome to the Board. Can you clarify. Single cell has 100 to 200 replies. Old comments show up first.

Are these actual cell comments (Like a post it note)?

Would you be able to show an example of what you have (you can hide any sensitive data) which may help in receiving a solution.

There is an Add-In called Inquire (Com Add-In) which will help analyse and show comments in an additional workbook that you can integrate etc.

Hi yes, actual cell coments

When you right click on a cell you can "Insert Comment"

It becomes a discussions thread for us

The problem is that is sorts oldest up top and news at bottom, so we always have to scroll down far to see the latest comment.

Thank you!