Apr 06 2019 10:20 AM
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
.
Apr 06 2019 10:46 AM
SolutionHi 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
However, if you workbook file shared you will see only Notes
And all options are to be on ribbon
Apr 06 2019 12:10 PM
@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.
Apr 06 2019 01:00 PM
@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.
Apr 06 2019 10:46 AM
SolutionHi 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
However, if you workbook file shared you will see only Notes
And all options are to be on ribbon