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

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.

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

You need to question the usual suspects:

Have the cells or worksheet or workbook become protected??
--
Gary''s Student - gsnu200858


"NauticVideo" wrote:

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.

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

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

On Sun, 21 Jun 2009 06:15:01 -0700, Gary''s Student
wrote:

You need to question the usual suspects:

Have the cells or worksheet or workbook become protected??

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

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" wrote:

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

On Sun, 21 Jun 2009 06:15:01 -0700, Gary''s Student
wrote:

You need to question the usual suspects:

Have the cells or worksheet or workbook become protected??

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

Good to hear.

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


Gord

On Sun, 21 Jun 2009 13:12:01 -0700, NauticVideo
wrote:

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" wrote:

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

On Sun, 21 Jun 2009 06:15:01 -0700, Gary''s Student
wrote:

You need to question the usual suspects:

Have the cells or worksheet or workbook become protected??