How did I lose ability to add/edit comments in Excel

  • Thread starter Thread starter NauticVideo
  • Start date Start date
N

NauticVideo

I am using Excel 2007 and have been inserting comments in cells in my
worksheet. I must have mis-typed something because suddenly I found myself
on a different sheet in the workbook and now I cannot insert or edit comments
in any cells in the workbook. The only comment option in the right click
menu is "delete", which appears in those cells with existing comments.
 
You need to question the usual suspects:

Have the cells or worksheet or workbook become protected??
 
I would guess that OP has more than one sheet selected.

If sheet was protected "delete comment" would also be grayed out.


Gord Dibben MS Excel MVP
 
Thanks Folks,

Gord's clue solved the problem. I didn't know it was even possible to group
sheets. Right click on one of the sheets and "Ungroup Sheets" worked for me.

Best Regards,
J. D. Jones
NAUTIC Video
 
Back
Top