• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 124
  • Last Modified:

Excel 2016 - Cannot Edit Existing Comment

Excel 2016/Win10:

Hey, everyone.

In an Excel sheet, I have a comment tied to cell B1. I need to edit it, so I go to REVIEW --> EDIT COMMENT. However, I can view only one line of the comment at a time, as seen in this screenshot.
Issue with Excel Comment

Any idea what causes this issue and how to get past it?

Thanks!
Steve
0
Stephen Kairys
Asked:
Stephen Kairys
  • 4
  • 4
3 Solutions
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Did you try resizing the comment? Also you can right click and choose Edit Comment as well.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Hi, Neeraj,

No luck. The comment does not seem to "want" to be resized. And when I right click, I see the following drop-down menu. (Oddly, a different menu came up one of the times I clicked.)

Right-click comment.
Btw, the FORMAT COMMENT option does not seem to allow for resizing.

Almost wondering if this comment is corrupted....

Thanks.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
It seems you right click in the comment itself while in editing mode. Try right clicking in B1 and choose Edit Comment and then try resizing the comment box. Are you able to do this?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
To check whether this issue is only for B1, try inserting a comment in a different cell and try resizing it and editing it. See if you can perform this action with comment in other cell.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thank you! Right clicking on B1 works for editing the comment. In fact, I did not have to resize to do the editing. However, only four of nine lines display. Same thing when I hover over cell B1.

I tried resizing. However, when I position my mouse over the lower border and drag it, the comment moves lower on the screen. How do I expand beyond four lines?
0
 
Mike in ITIT System AdministratorCommented:
Expanding the comment should not be difficult. When you right-click on the cell and select "Edit Comment" the comment box should pop-up with the little squares at each corner and at the midpoint of each side.

Comment.PNG
If you hover over the one in the middle of the bottom of the comment you can stretch it down to see the whole 9 lines. Like in my picture above.

If you could attach a copy of your spreadsheet we could see if there is something else preventing this from happening.

I am able to stretch mine to any size I want even if the text doesn't go that far.

Comment.PNG
Your pointer should look something like this to resize the comment:
Size.PNG
It would look like this to move the comment around the screen:Move.PNG
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Mike, thank you. I did not see the little squares. Stretching the one in the lower-middle worked for me.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thank you Neeraj and Mike. Good collaboration!
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome! Glad we could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now