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

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

Gary''s Student

You need to question the usual suspects:

Have the cells or worksheet or workbook become protected??
 
G

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
 
N

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
 
G

Gord Dibben

Good to hear.

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


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top