Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel 'comment' question.

Pigman II · 2004-06-08 19:26:46

In Excel there is a facility to add a 'comment' to a cell - usually looks something like a yellow 'post it' note when your mouse hovers over the cell in question. The area of this comment is set as a default but can be reduced/increased manually. What I was wondering is there anyway to get excel to AUTOMATICALLY resize the…

08-06-2004 08:26PM

#1

Pigman II

Closed Accounts Posts: 10,921 ✭✭✭✭

Join Date: January 2003

Posts: 10419

In Excel there is a facility to add a 'comment' to a cell - usually looks something like a yellow 'post it' note when your mouse hovers over the cell in question.

The area of this comment is set as a default but can be reduced/increased manually.

What I was wondering is there anyway to get excel to AUTOMATICALLY resize the area of the comment to fit around whatever amount of text it holds?

I've checked 'help' and it doesn't seem to have anything other than the manual method. I've also checked google too at this point but no luck.

All advise/suggestions gratefully recieved.

0

Comments

#2 08-06-2004 10:40PM

KdjaCL

Closed Accounts Posts: 20,346 ✭✭✭✭

Join Date: February 2002

Posts: 18144

When you in the comment box hit delete and it will kinda word wrap around your text. It will delete the extra space.
Its not perfect but it works.
There is a way to word wrap but i never found it other than above.
kdjac

0