"New Note" missing in Excel

Question

I'm working in Excel with Microsoft Office Professional Plus 2021, updated with Microsoft 365.

For school purposes, I need to be able to add/insert comments and notes to a cell.

Unfortunately, I only have access to comments. So, I can't add a note.

It's not available when I click right on a cell or in the "Review" tab.

I've tried to:

• Open a new workbook
• Update my program
• Open my doc in Excel safe
• Repair Microsoft 365 in Control Panel
• Checked in File - Options - Advanced in which there is only the mention of comments, no note
• In Microsoft Visual Basic for Applications, I've implemented the workaround stated in https://support.microsoft.com/en-us/topic/missing-new-comment-and-new-note-from-excel-s-context-menu-d92fac0d-1d14-4fa2-a597-a880e776d177

1. Open the Visual Basic Editor (VBE) by pressing Alt+F11.
2. Insert a new module from Insert> Module.
3. Copy and paste the following code into the empty module pane on the right: Sub ShowButtonsAgain()
      Dim bar As CommandBar
      For Each bar In Application.CommandBars
            bar.Reset
      Next
   End Sub
4. Press F5 to run the code.
5. Exit back to Excel by pressing Alt+Q, and verify that the Comment and Note options have been restored.

Nothing has worked.

Does anyone have a fix?

Thank you so much for your attention and participation.

EDIT: Moved FROM Microsoft 365 and Office / Excel / Unknown / Windows TO Microsoft 365 and Office / Excel / For Education / Windows.

Answer 1

It’s possible that your administrator has disabled this feature through group policy. Then it cannot be found anywhere in Excel.

Answer 2

Hello

I use Microsoft 365 Personal version but I have the same situation

I do following the guidelines, nothing happens

Please explain more details

Answer 3

I experienced this "New Note" missing problem twice so far. A few weeks back, I was in a hurry and had to ignore the problem without giving it any additional time. I did not insert any note. But today it happened again, and this time I could trace at least one reason that caused the problem.

I had selected several (actually three) worksheets using shift click on worksheet tab names to apply a uniform format to all worksheets. I forgot to unselect the worksheets after applying the desired format and started working on sheet1 but in the background all my work on sheet1 was also getting copied on all other sheets. In this situation insert new note option was not offered and to get it back you needed to be working on only one sheet at a time. I cleared the work done on sheet1 from the remaining two sheets and I got the insert new note option back in the context menu as it used to be.

Answer 4

Thank you for sharing.

Answer 5

Hi,

I believe the New Note option is not on the menu. However, if you right-click a cell you will see both New Note and New Comment:

You can add the command to the ribbon or the QAT or both. I have done that in the screenshot below: