Bring back Edit Comments (Legacy) to the Right-Click Menu
The new Threaded Comments that appeared in Build 1809 are awesome for 99% of the people. But for the Commenting Gurus - anyone who has ever taken the time to build help systems by resizing, re-coloring, re-shaping and using Show All Comments, we are going to see our comments get destroyed by well-meaning co-workers.
Yes, all of the legacy icons are available for adding back to the Ribbon, but we the comment gurus can not trust our co-workers and managers to take the time to add these.
My request: If Excel detects any comment in the workbook that is a different color, a different size, a different shape, holds a photo, or if Show Comment is turned on, then do not offer our co-workers the option to "Reply to Comment" and then default to "Convert Comments". That "Convert Comments" button is global and permanent and might as well say "Undo all the work that our genius co-worker did in building this help system."
At the very least, add "Edit Comment (Legacy)" to the right-click menu, just above "Reply to Comment" so we have a 50/50 shot that our comments will not be destroyed by our manager. Please.
We have addressed the topic of this suggestion by bringing back the legacy comments as notes and included the edit comment action as “edit note” in the right click menu. Also, this topic has multiple suggestions, so if for any remaining suggestions which are not covered by the update to reintroduce legacy comment editing, please open a new suggestion. Thank you.
John Sindell commented
I too want a way to edit my customized Legacy Comments. The new Threaded Comments are nice, and the new Notes appear to be the same as the Legacy Comments with all of the formatting still available, however my older legacy Comments are unable to be edited or deleted, or even cleared, unless I clear everything from the cells. My old Legacy Comments still function properly, but they are not recognized by the new Notes. Unlike Bill and his version, my Excel does not allow me to even add the Legacy Comment icons back into the Ribbon or QAT. They simply are not available as icons/commands to add.
If the Notes (NOT the new threaded Comments) would simply recognize the Legacy Comments, I think all would be well, at least in my sheets.
John Schuyler commented
The right-click cell, New Note option is no longer showing on the drop-down list (as of approximately 1/6/19). Please restore or bring this back as described in:
William Clark commented
These are good ideas to help protect the extensive work and value that is created by some and that can too easily be destroyed by others that don't know, understand, or care about that value. Protection features should be added, to preserve the good work. I like the idea of a new system (that separate from Comments) and is better suited to the special help systems, etc. If such a system is added, there should be a well thought out, robust (& possibly feature rich) tool for converting Comments to the new system.
Agree with Bill
I disagree. This shouldn't be a thing done by excel automatically, but an option which is part of the comment object.
If there was some "freeze comments" option this would be ideal and shouldn't be hard to implement.
Elijah Hubley commented
I agree with Bill, for all the same reasons he mentioned.
Excel gurus can learn to cope with changes, but because comments often exist specifically for those who are less skilled at Excel, this change poses a problem.
I definitely agree with Bill. Or, just prevent the "Reply to Comment" from changing existing formatting.
Agree with Bill
You can just do Shift+F2 and it pops up your comment or create new comment in the current cell which is selected. and after that just hit space bar and you will be in edit mode
MM Cromarty commented
Having comments go wonky after getting them set up perfectly is endlessly frustrating. Bill's request is excellent and has my support.
While we're talking about comments, could an option be added like that found in Format Picture: > Move... with cells; or > Don't move... with cells. (In a big worksheet, I'd like the comment to remain with the cell, not end up several hundred rows below it.)
bring back Edit Comments to right click menu
Thomas Organtzis commented
Bring back Edit Comments to right click menu.
Bill, I totally agree. I use comments extensively for help tips, insert .jpegs of source documents for reference and all manner of custom modifications. We do need some safeguard against inadvertently wiping out that work.
Shaun Gartland commented
I use legacy comments in a lot of work books
Please do not allow other users to converts these to threads
Thanks Microsoft for an awesome product
Ute Simon commented
Maybe we should not have old and new comment styles in future versions of Excel. But get the option to insert "comments" (for collaboration) and "help shapes" (resembling the look of the old comments and formattable) like the Screen Tips shown in the Ribbon.
Mark Rosenkrantz commented
I agree with Bill.
At least offer those who implemented that hard commenting work (as a part of a help system) the option to keep that hard work visible and editable.
Mark Rosenkrantz > Spreadsheet Solutions > Netherlands
Agree. Bill's idea helps protect the integrity of of the comments meaning, and prevents work from being undone.
I use comments to help highlight different forms of action items.
Completely agree. Legacy comments aren't only used to collaborate! They are often used as tool tips, or notes to the user of the workbook.
These don't fit the use-case that the new Threaded Comments feature tries to solve for.
As it stands, even the developer of the workbook won't be able to edit these type of comments without converting them into threads. Not to mention, allowing a user to effectively destroy these legacy comments is a bad thing.
When a legacy comment is activated, the options should be:
Edit Comment | Convert to Thread | Cancel
I agree with Bill. Don't toss away my hard work.
Mourad Louha commented
as additional suggestions/thoughts, I think, that answering to an old comment from the context menu and therefore perform a conversion of the old comment should only apply to the selected comment and leaving the other comments as is. Converting all comments to the new format should imho be a feature in the ribbon, as this feature applies globally.