SOLVED
Home

Simple comment for a cell. Functionality that has been around for decades is just gone.

%3CLINGO-SUB%20id%3D%22lingo-sub-401273%22%20slang%3D%22en-US%22%3ESimple%20comment%20for%20a%20cell.%20Functionality%20that%20has%20been%20around%20for%20decades%20is%20just%20gone.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401273%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20to%20buy%20a%20new%20windows%2010%20PC%20because%20of%20a%20crash%2C%20and%20bought%20a%20new%20office%20pack%20also.%20I%20have%20been%20using%20excel%20for%20many%20years%20and%20all%20versions%20have%20supported%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20should%20work%20with%20my%20customeraccounting%20and%20should%20make%20a%20note%20on%20an%20irregularity%20for%20a%20customer%2C%20something%20that%20is%20rare%20and%20the%20cell-comment%20function%20is%20good%20enough.%20I%20then%20notice%20that%20I%20can%20not%20reach%20the%20function.%20The%20three%20lines%20related%20to%20this%20in%20the%20right-click%20popup%2C%20are%20missing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20investigate%20a%20cell%20which%20already%20has%20a%20comment.%20And%20there%20I%20see%20the%20comment%20functionality%20in%20the%20right%20click%20popup.%20Pls%20explain%20how%20to%20solve%20this.%3C%2FP%3E%3CP%3EKind%20regards%2C%20Per%20Bystr%C3%B6m%3C%2FP%3E%3CP%3E%26nbsp%3B%20.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401273%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401313%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20comment%20for%20a%20cell.%20Functionality%20that%20has%20been%20around%20for%20decades%20is%20just%20gone.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315349%22%20target%3D%22_blank%22%3E%40perby123%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome.%3C%2FP%3E%0A%3CP%3EThat%20is%20still%20a%20transition%20period.%20In%20some%20versions%20of%20Excel%20we%20have%20only%20old%20comments%2C%20aka%20notes%2C%20aka%20annotations.%20New%20versions%20set%20them%20aside%20and%20now%20it%20is%20much%20more%20stress%20on%20new%20comments.%20Each%20has%20it's%20own%20pros%20and%20cons.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401298%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20comment%20for%20a%20cell.%20Functionality%20that%20has%20been%20around%20for%20decades%20is%20just%20gone.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401298%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EThanks%20Sergej.%20There%20must%20be%20at%20least%20four%20users%20world%20wide%20that%20have%20been%20longing%20for%20this%20user%20interface%20change%20(note%3A%20irony).%20But%20now%20I%20create%20the%20comment%20with%20Notes%20in%20the%20top%20menu%20but%20afterwards%20the%20comment%20is%20visible%20exactly%20as%20it%20used%20to%20be%20and%20can%20be%20handled%20efficiently.%26nbsp%3B%20So%20I%26nbsp%3B%20can%20cope%20(not%20at%20all%20irony).%26nbsp%3B%20Thanks%20again%20very%20much.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401280%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20comment%20for%20a%20cell.%20Functionality%20that%20has%20been%20around%20for%20decades%20is%20just%20gone.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401280%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Per%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20which%20version%20of%20Office%20you%20are%20and%20how%20do%20you%20use%20your%20file.%20In%20modern%20Excel%20what%20is%20was%20comments%20before%20now%20is%20called%20Notes%3B%20and%20in%20it%20are%20added%20Comments%20which%20have%20bit%20another%20functionality%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Finsert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Finsert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8%3C%2FA%3E%3C%2FP%3E%0A%3CP%3ERight%20click%20menu%20shows%20both%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20248px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106011i182CBBD616726B92%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHowever%2C%20if%20you%20workbook%20file%20shared%20you%20will%20see%20only%20Notes%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20210px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106012iA4582B241F527C57%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAnd%20all%20options%20are%20to%20be%20on%20ribbon%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20365px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106013iC6BFFCEC47C8CFF9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315349%22%20target%3D%22_blank%22%3E%40perby123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
perby123
New Contributor

I had to buy a new windows 10 PC because of a crash, and bought a new office pack also. I have been using excel for many years and all versions have supported this. 

 

Now I should work with my customeraccounting and should make a note on an irregularity for a customer, something that is rare and the cell-comment function is good enough. I then notice that I can not reach the function. The three lines related to this in the right-click popup, are missing.

 

I then investigate a cell which already has a comment. And there I see the comment functionality in the right click popup. Pls explain how to solve this.

Kind regards, Per Byström

  .  

3 Replies
Solution

Hi Per,

 

It depends on which version of Office you are and how do you use your file. In modern Excel what is was comments before now is called Notes; and in it are added Comments which have bit another functionality https://support.office.com/en-ie/article/insert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-...

Right click menu shows both

image.png

However, if you workbook file shared you will see only Notes

image.png

And all options are to be on ribbon

image.png

 

@perby123 

@Sergei BaklanThanks Sergej. There must be at least four users world wide that have been longing for this user interface change (note: irony). But now I create the comment with Notes in the top menu but afterwards the comment is visible exactly as it used to be and can be handled efficiently.  So I  can cope (not at all irony).  Thanks again very much. 

@perby123 , you are welcome.

That is still a transition period. In some versions of Excel we have only old comments, aka notes, aka annotations. New versions set them aside and now it is much more stress on new comments. Each has it's own pros and cons.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies