Dear all
In Excel 365 is there a way to sort the new style threaded comments (not Notes formerly known as comments in older versions) by date?
Currently when you choose Review > Show comments - They are listed in order of cell reference. It would be useful to sort these by date to see the most recent comments at the top of the list. As this doesn't appear to be a built in function I assume that it may require a VBA solution.
Any help appreciated!
Last edited by ljerromes; 12-02-2020 at 07:55 AM.
that would not make any sense for a few reasons:
1) what you tried is a menu option. not code.
2) listing comments by date would confuse a typical MS user who knows nothing about anything.
3) it would not be consistent traditional sort features of software programs. cells in this case are threads, just like this thread I am posting in now is a conversation. conversations are relevant. they are productive. thus, showing comments by cell refs is by conversation. you can get more done. if you sort by date, the cell refs go all over the place and the conversations make no sense to a typical ignorant user. =(
however, there might be an answer here:
https://www.google.com/search?q=excel+365+sort+comments
you will also want to bookmark this forum:
https://answers.microsoft.com/en-us
click on "ask a question at the top", then sign in. you can ask anything, and MS contractors and freebie-workers answer those thing seepdy fast in this day in age. they're scared to death to lose any dime of revenue. see images below for steps:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks