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

[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.

 

[Gary''s Student]

You need to question the usual suspects:

Have the cells or worksheet or workbook become protected??

 

[Gord Dibben]

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

 

[NauticVideo]

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

 

[Gord Dibben]

Good to hear.

Your some kind of key stroke was probably CTRL or SHIFT + click


Gord