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
LVL 4
Stephen KairysTechnical Writer - ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Did you try resizing the comment? Also you can right click and choose Edit Comment as well.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.