turn on insert comments ability in Excel

D

dave parta

I have an Excel file with the ability to insert comments turned off. I need
to turn it on. The 'show insert options' button is checked. I still can't
insert comments.
 
K

Kevin B

Sounds like the cell you're attempting to add the comment to is locked due to
worksheet protection being turned on.
 
G

Gord Dibben

Unprotect the sheet or if you need it protected, check the "Edit Objects" option
when protecting the sheet.

Note: "show insert options" has nothing to do with inserting Comments.

That just pops up a dialog of choices when you insert a row or cell.


Gord Dibben MS Excel MVP
 

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