Excel 2016 - Cannot Edit Existing Comment

Stephen Kairys
Stephen Kairys used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Did you try resizing the comment? Also you can right click and choose Edit Comment as well.
Stephen KairysTechnical Writer - Consultant

Author

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.
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
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?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
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.
Stephen KairysTechnical Writer - Consultant

Author

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?
Mike in ITIT System Administrator
Distinguished Expert 2017
Commented:
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
Stephen KairysTechnical Writer - Consultant

Author

Commented:
Mike, thank you. I did not see the little squares. Stretching the one in the lower-middle worked for me.
Stephen KairysTechnical Writer - Consultant

Author

Commented:
Thank you Neeraj and Mike. Good collaboration!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome! Glad we could help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial