Add / Edit Note to Excel cell has disappeared

%3CLINGO-SUB%20id%3D%22lingo-sub-2228499%22%20slang%3D%22en-US%22%3EAdd%20%2F%20Edit%20Note%20to%20Excel%20cell%20has%20disappeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2228499%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20opened%20a%20file%20I%20was%20working%20on%20yesterday%20and%20have%20noticed%20that%20the%20ability%20to%20Add%20%2F%20Edit%20Notes%20and%20Comments%20has%20disappeared%20from%20the%20'right-click'%20menu%20for%20all%20cells.%26nbsp%3B%20I%20have%20not%20protected%20any%20cells%20or%20sheets%20within%20the%20Workbook%20but%20have%20no%20idea%20why%20its%20gone.%26nbsp%3B%20Any%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2228499%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2229178%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20%2F%20Edit%20Note%20to%20Excel%20cell%20has%20disappeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229178%22%20slang%3D%22en-US%22%3EIf%20I'm%20not%20wrong%20then%20you%20are%20struggling%20with%20COMMENTS%2C%2C%2C%20do%20this%2C%2C%2C%20select%20the%20cell%20then%20right%20Click%20%26amp%3B%20from%20the%20menu%20find%20Hide%2FUnhide%20Comment%2C%2C%20hit%20once%20sets%20the%20comment%20appears%20(if%20is%20hidden)%20another%20sets%20comments%20disappear%20(%20if%20is%20Un-hidden)%20.%3C%2FLINGO-BODY%3E
New Contributor

I have opened a file I was working on yesterday and have noticed that the ability to Add / Edit Notes and Comments has disappeared from the 'right-click' menu for all cells.  I have not protected any cells or sheets within the Workbook but have no idea why its gone.  Any help would be appreciated.

5 Replies
If I'm not wrong then you are struggling with COMMENTS,,, do this,,, select the cell then right Click & from the menu find Hide/Unhide Comment,, hit once sets the comment appears (if is hidden) another sets comments disappear ( if is Un-hidden) .

@Rajesh-S Thanks for the reply.  I am aware of the menu that appears when you highlight a cell and 'right click'.  The issue is that the menu appears when I 'right-click' but the options to Add / Edit / Delete both Notes and Comments has disappeared from the menu.

@Fencote 

I'd check in Safe mode (Win+R, excel /safe) if it works or not, next do Office repair.

It's unusual activity since Insert Comments & then others are built in commands,,, one you try SHIFT+F2 ,,,, I'm sure this will works.

@Fencote 

 

You may try this as a trouble shooter:

 

Try this VBA Macro:

  • To open the VB Editor  press Alt+F11.
  • Insert a new module from Insert  then Module.
  • Copy and Paste this code. 

 

 

 

Sub ShowCommandButtons()
   Dim bar As CommandBar
   For Each bar In Application.CommandBars
         bar.Reset
   Next
End Sub

 

 

 

  • Save the WB as Macro Enabled *.xlsm.
  • Press F5 to run the Macro.

 

N.B.

 

  • Back to sheet & insure that the Comment/Note commands have been restored or not. 
  • Remember Comments is available with every version of Excel but the Note is with higher versions only.